Counting column based on date and department


I am trying to sum the number of rows that fall in a certain date period and based on department

This is what I came up with but it just returns 0's, Should I be using a different formula like COUNTIF?

=SUMIFS(Department:Department, [Week Ending]:[Week Ending], >=TODAY(-5), Department:Department, "Tech Unit D")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!