SUMIFS with sheet references.


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.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!