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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!