COUNTIFS, Dates + 7, Checkbox Unchecked
Each day, I want to create a running total of unchecked checkboxes for today and the previous 7 days.
For this sheet, I need a Countifs, that will count from the date column and the previous 7 days of unchecked boxes for each column. It will be a total of unchecked boxes for all columns for today + the previous 7 days. (for the first row, it should just count the day).
I know this will be a COUNTIFS + formula, where I am really having problems is how to get it to count today + the last 7 days as of the date in the date column.
Thanks for your help!!
Help Article Resources
Check out the Formula Handbook template!