COUNTIFS with Multiple Criteria


I am trying to count the overtime "Yes" in a given week by matching the Department "Tech Unit D"

The formula I am working with always brings back Zero: I've tried with and without and. Any help would be greatly apricated, I'm a newbie to this :)

=COUNTIFS([Week Ending]:[Week Ending], >=TODAY(-5), [Overtime?]:[Overtime?], "Yes", Department:Department, "Tech Non-Rep")

I was able to count to OT in a week by using this formula but can't get it to work when adding in the actual department

=COUNTIFS([Week Ending]:[Week Ending], >=TODAY(-5), [Overtime?]:[Overtime?], "Yes")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!