SUMIFS with sheet references.

Richard Lucas

Hello,

I've got this formula working like this.

=SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "Vacation")

However when I change the criteria to "PPL / Sick" it's returning 0 when there are clearly cells to count.

=SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "PPL / Sick")

I've tried the same with other criteria and it seems to be just this one.

Jeff Reisman

I suspect it's the special character "/" in your criteria. Change your values and remove the slash, and change the formula to match, and see how it works then.

Richard Lucas

Changed the / to - and it worked. Must not like the /.

Jeff Reisman

I suspect it's the special character "/" in your criteria. Change your values and remove the slash, and change the formula to match, and see how it works then.

Paul Newcome

You would also want to ensure that the data in the sheet matches your criteria to include the spaces on either side of the slash. Upper vs lower case doesn't matter, but everything else needs to match.

Richard Lucas

Changed the / to - and it worked. Must not like the /.

Jeff Reisman

@Richard Lucas Glad it worked for you!