Multi-Layer Formula for COUNTIFS and IF

Multi-Layer Formula for COUNTIFS and IF

Hello,

I am trying to see the number of employees that called off for each shift for yesterday only. This is what I have so far. I want to see the number of employees that called off on "Shift A" and that call off is "Unscheduled" , but ONLY want to see any calls with the call-off date that was yesterday.

Do I need an "And" in there somewhere?

=COUNTIFS({CMHIP Employee Call Off Log Range 1}, "Shift A", {CMHIP Employee Call Off Log Range 2}, "Unscheduled", IF({CMHIP Employee Call Off Log Range 3}@row = TODAY(-1)))

Best Answer

Answers

Sign In or Register to comment.