View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default count number of "D"

Hi Jayender,

Try:

=COUNTIF(C:C,"m*")


---
Regards,
Norman



"jayender.vs"
wrote in message
...

Hey then dude,
got one doubt
say i need to calculate number of "m" present in the column.. its like
this

max, matter, mass, apple, orange...

and from this i need to count number of words starting with letter
"m".
how to do it?

waiting for ur responce.


thanks,
jay


--
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