In AK4 introduceti formula:
Cod: Selectaţi tot
=SUMPRODUCT(--(C4:AG4="CO"),--(WEEKDAY($C$2:$AG$2,2)<6))*8
Cod: Selectaţi tot
=SUMPRODUCT(--(C4:AG4="CO"),--(WEEKDAY($C$2:$AG$2,2)<6))*8
Cod: Selectaţi tot
=NETWORKDAYS(E3,F3, $D$9:$D$38)-1
Cod: Selectaţi tot
#"Grouped Rows1" = Table.Group(#"Changed Type1", {"a"}, {{"Rezultat", each Text.Combine([Interval], "; "), type text}})
Centrul de training si consultanta IT Learning activeaza de peste 15 ani pe piata serviciilor de instruire si certificare IT din Romania. |
Link-uri utile |
Categorii de cursuri |
Contact |
© 2019 IT Learning Business Intelligence School - Citeste termeni si conditii |