COUNIF Range with two requirements?

Ryan Nix

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?

Mike Wilday

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.

Mike Wilday

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.

Ryan Nix

Looks like that helped, thanks!

Mike Wilday

Awesome, glad I could help you out.