Need a function
 

Hi All,
I need a function or something that will make my file work. What I want
to do is get all the one colum go down and check to see if there is a
"W","P", or "C". And when it finds one there it will add to the my
total count. For example:
Column B
1 W
2 C
3 W
4 W
5 P
6 C
7
8
9 W
10 P

Total W = 4
Total P = 2
Total C = 2


PS I'm sending a file along with this just to show


+-------------------------------------------------------------------+
|Filename: Total Letters.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3543 |
+-------------------------------------------------------------------+

--
jcc31
------------------------------------------------------------------------
jcc31's Profile: http://www.excelforum.com/member.php...o&userid=24692
View this thread: http://www.excelforum.com/showthread...hreadid=382619

If I understand correctly, youwant the COUNTIF function
=COUNTIF(A1:A10,"W") adapt as necessary. Is that it?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=382619

PREFECT!!!!!
I did know there was a function like that.
Sorry, I new to excel


--
jcc31
------------------------------------------------------------------------
jcc31's Profile: http://www.excelforum.com/member.php...o&userid=24692
View this thread: http://www.excelforum.com/showthread...hreadid=382619