COUNIF Range with two requirements?
Hi all,
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?
Best Answer
-
You have to check each column individually.
Try this revision:
=COUNTIFS(Building:Building, Location@row, OR(@cell([SignageA]:[SignageA]), "Yes", @cell([SignageB:[SignageB]), "Yes", @cell([SignageC]:[SignageC]), "Yes", @cell([SignageD]:[SignageD]), "Yes")\
Let me know if it works.
Answers
-
You have to check each column individually.
Try this revision:
=COUNTIFS(Building:Building, Location@row, OR(@cell([SignageA]:[SignageA]), "Yes", @cell([SignageB:[SignageB]), "Yes", @cell([SignageC]:[SignageC]), "Yes", @cell([SignageD]:[SignageD]), "Yes")\
Let me know if it works.
-
Looks like that helped, thanks!
-
Awesome, glad I could help you out.
Help Article Resources
Categories
Check out the Formula Handbook template!