What formula should I use to count R,Y,G symbols in a column?

Hey folks,

I want to count the number of red, yellow, and green symbols in a column. Does anyone know the formula to achieve that result?

Thanks,

Kenny

Find more posts tagged with

Formulas

Countif is your friend here...

=Countif( [Column with Symbols]:[Column with Symbols], "Red")

=Countif( [Column with Symbols]:[Column with Symbols], "Yellow")

=Countif( [Column with Symbols]:[Column with Symbols], "Green")

Hi Brett,

Thank you very much for the assistance. I'll give that a try.

Very much appreciated,

Kenny