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

Kenny Vick

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

Brett Evans

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")

Kenny Vick

Hi Brett,

 

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

 

Very much appreciated,

Kenny