SumIF/CountIF not Working
Help please... why is it that my formula is returning a "0" zalue in Timecard Completed1 field when it should technically return a "1"?
Formula being used: =SUMIF(($PPE$10:$PPE$172), $PPE@row, ([Timecard Complete Helper]$10:[Timecard Complete Helper]$172))
I'm trying to get the 'Timecard Completed' column to count the total number of Employee's that Completed their timecards in a specific Pay Period. NOTE: The formula works if I hardcode the number "1" in the individual line items (e.g., [Timecard Complete Helper]12)
FYI: 'Timecard Complete Helper' rows are calculating based on the value in the 'Timecard Completed' column with the formula =IF([Timecard Completed]@row = "Yes", "1", "") - Ideally, I'd rather it be running of a Checkbox instead.
Help Article Resources
Check out the Formula Handbook template!