Posted to microsoft.public.excel.programming
|
|
Count by the Text
=countif("R:R","F")
replace F iwth P, N, D
Change R:R to refer to the column with the data
--
regards,
Tom Ogilvy
"dragontale " wrote in message
...
All,
I have one column have text value as "F", "P", "N", "D", And I want to
count how many "F" I have and then put the number into another cell. I
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. Thank
you in advance.
Regards,
---
Message posted from http://www.ExcelForum.com/
|