COUNIF Range with two requirements?
This feels like it should be rather simple but I am getting an incorrect argument set. The formula I am using is: =COUNTIFS(Building:Building, Location@row, [SignageA]:[SignageD], "Yes")
Basically, there are multiple columns for the signage that we need to check and compare it to the location so we can have a roll up by building on how many have been set up.
Is there something glaringly obvious that I am missing?
Help Article Resources
Check out the Formula Handbook template!