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
Check out the Formula Handbook template!