Summary Function with Date Range
I am attempting to create a sheet summary row function that will count a response of "Staff is Non-compliant" in the "Reason Not Reported" column for a specific date range (the week prior to the reporting week).
My goal is to be able to display the number of non-compliant for the current week in a dashboard.
I have tried the following formula, and multiple variations, but am not able to get the function to work.
Any and all assistance would be greatly appreciated!
=COUNTIF([Reason Not Tested]:[Reason Not Tested], "Staff is Non-compliant" "&[Week Start Date]:[Week Start Date], DATE(>=TODAY-11)&[Week Start Date]:[Week Start Date],DATE(<=TODAY)
Help Article Resources
Check out the Formula Handbook template!