=COUNTIF(A1:A7,"*d")

assuming these entries are in a1 to a7



"jayender.vs"
wrote in message
...

Hi dude,
I am new to excel .. here is my requirements.

Code:
--------------------

449 78 d
449 69 m d
458 260 m
469 28 m
472 39 m
479 51 d
484 59 m d
--------------------

i need to count number of "d" present in the 4 th column and number of
m present in the 3 column.. its a very big table and i need to
calculate programically.
how to do it?

thanks in advance !!


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035