Count nr. of checkboxes based on another value
I have a sheet with actions. It has a status column (in progress and not started). Further in the sheet I have checkboxes per department. I'm trying to build a report, that shows the number of actions that have status in progress for the specific department.
I can do the count of the checkboxes. but need to have the condition build-in.
Help Article Resources
Check out the Formula Handbook template!