Count by the Text

D

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
 
T

Tom Ogilvy

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

replace F iwth P, N, D


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