Posted to microsoft.public.excel.programming
|
|
count number of "D"
Hi Jayender,
Try:
=COUNTIF(C:C,"m")
=COUNTIF(D:D,"d")
---
Regards,
Norman
"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
|