Countif yellow or red status symbol

cfischer

Hi Smartsheets community, 

Does anybody know how to count how many cells have one of two status symbols colors (e.g., either yellow or red)?

 

My current formula is =countif(or(range:range "yellow", range:range "red")). 

 

Any help would be much appreciated!

-cfischer

Dominik Weller

Hi cfischer,

I don't know if there's a more elegant way to do this, but you could use the following formula:

=SUM(COUNTIF(range:range; "yellow"); COUNTIF(range:range; "red"))

Greetings

PS: Maybe you have to exchange all semicolons ; with commas , ... Since I use german language settings, this may not work for you.

L_123

try count(collect())