Counting Multiple Symbols

Aimee Eckert

Hello!

I have tried COUNTIF and COUNTIFS trying to get the count of "Yellow" and "Red" symbols. I'm using Green, Yellow, and Red.

Is there a formula that will populate the total of the Yellow and Red within a single column?

Heather Duff

Hi @Aimee Eckert ,

Try this, where [column name] is in place of your column name:

=COUNTIF([column name]:[column row], OR(@cell="Red", @cell="Yellow"))

You could also do it separately:

=COUNTIF([column name]:[column row], "Red") + COUNTIF([column name]:[column row], "Yellow")

Hope this helps! Let me know if it works.

Best,

Heather

Aimee Eckert

I used =COUNTIF([column name]:[column row], OR(@cell="Red", @cell="Yellow"))

It worked perfectly! Thank you so much!

Heather Duff

@Aimee Eckert Fantastic! Happy to help. Have a great weekend.