Count by the Text

[dragontale]

All,

I have one column have text value as "F", "P", "N", "D", And I want t
count how many "F" I have and then put the number into another cell.
need to do the same to other values too (P, N and D)

How to do this? I have tried a few formula, but it doesn't work. Than
you in advance.

Regards

 

[Tom Ogilvy]

=countif("R:R","F")

replace F iwth P, N, D


Change R:R to refer to the column with the data

 

[dragontale]

Awsome. Thanks a lot !

Regards