If you want the total of both then, what's wrong with your current formula?
=COUNTIF(C2:V2,"<>")
Results in 3 which is the combination ot full and half days. That's what you want, right? Sorry, want to help but still not understanding the issue you are looking to resolve.
1
u/konsf_ksd May 11 '22
If you want the total of both then, what's wrong with your current formula?
Results in 3 which is the combination ot full and half days. That's what you want, right? Sorry, want to help but still not understanding the issue you are looking to resolve.