Formula Help - Counting Multiples as 1
Hello - Need some help figuring out the correct formula to use for what I need. I've put a sample data table below. Essentially, let's say I have a sheet of requests that I need to to track by category. 1 category may have several rows but I only need to count 1 for any of that category that have an unchecked box. See data table below for this to make a bit more sense (made up data for confidentiality reasons)
In this sample, This would be the output I was looking for:
Category 1: 2
Category 2: 1
Essentially if looking by project and category, if all the checkboxes are checked, then it is 0. If any are unchecked it is 1.
Hope this makes sense and looking forward to someone's input!