Help with SUMIF formulas for a daily headcount worksheet

  • Thread starter Thread starter MMcCullar
  • Start date Start date
M

MMcCullar

I am trying to set up a spreadsheet for my company to track the dail
headcount. I have a workbook for attendance which has each date in ro
3 and attendance codes in each date's column, i.e. "OFF" for schedule
day off, "PP" for pre-approved day off, etc. I am trying to set up
worksheet to count the daily headcount. For example:

{=SUM(B22-SUM(IF(Gardner!$3:$3=$E$1,IF(Gardner!$L$3:$HY$27="PP",1,0),0))-SUM(IF(Gardner!$3:$3=$E$1,IF(Gardner!$L$3:$HY$27="OFF",1,0),0)))}

Where "Gardner" is the attendance worksheet in question, E1 is today'
date in the headcount worksheet, B22 is the total number of people o
the supervisor's team, the range "Gardner!$3:$3" contains the dates i
the supervisor's attendance sheet, and the range "Gardner!$L$3:$HY$27
contains the specific attendance codes. When I try to validate th
formula, I keep getting 0 for my sumif formulas, regardless of how man
PP's and OFFs may be in that day's column. How do I get this to wor
properly, if at all
 
Hi
if I understood you correctly try
=B22-SUMPRODUCT((Gardner!L3:HY3=E1)*(Gardner!L4:HY27={"OFF","PP"}))
 
Back
Top