Forum Discussion
formula help
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 ad...
Thanks for the reply. And apologise as I am still struggling. Basics only here for me.
If I add this to my current count formulas it counts as two
+COUNTIF(E3:E72,"E12")+COUNTIF(E3:E72,"N12")
I want them to count as one. E12+N12=1.
I hope that makes sense 😞
If I add this to my current count formulas it counts as two
+COUNTIF(E3:E72,"E12")+COUNTIF(E3:E72,"N12")
I want them to count as one. E12+N12=1.
I hope that makes sense 😞
here are a few options maybe
MIN( COUNTIF(E3:E72,"E12")+COUNTIF(E3:E72,"N12") , 1)
MAX( COUNTIF(E3:E72,"E12"), COUNTIF(E3:E72,"N12") )
--OR( COUNTIF(E3:E72,"E12"), COUNTIF(E3:E72,"N12") )
MAX( (E3:E72="E12")+(E3:E72="N12") )
MIN( COUNTIF(E3:E72,"E12")+COUNTIF(E3:E72,"N12") , 1)
MAX( COUNTIF(E3:E72,"E12"), COUNTIF(E3:E72,"N12") )
--OR( COUNTIF(E3:E72,"E12"), COUNTIF(E3:E72,"N12") )
MAX( (E3:E72="E12")+(E3:E72="N12") )
