Mar 27 2023 03:27 PM
Hi
I create the roster at work and stuck on how to create a formula
I'm fine the basic COUNTIFS, but we are introducing 12 hours shifts,
I have E for early
L for Late
N for night
What I'm adding is E12 & N12
E12 easy enough to be included in the count of all the rostered E's
=COUNTIF(E1:E72,"E")+COUNTIF(E1:E72,"E6")+COUNTIF(E1:E72,"I/C")+COUNTIF(E1:E72,"CL")+COUNTIF(E1:E72,"E12")
and N12 easy enough to counted in the Ns
My problem is I need to count both E12 + N12 as one and to be calculated in the Late shifts
=COUNTIF(E3:E72,"L")+COUNTIF(E3:E72,"LC")+COUNTIF(E3:E72,"FU")
And I'm stuck
Any help is appreciated Thanks
Mar 27 2023 03:45 PM
Mar 27 2023 04:15 PM
Mar 27 2023 04:32 PM