View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
japc90 japc90 is offline
external usenet poster
 
Posts: 58
Default Counting Specific Text

On Jan 6, 2:05*pm, "Ron de Bruin" wrote:
Maybe

=COUNTIF(A1:A50,"math")

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"japc90" wrote in ...
I want to type a formula that will look at a range of cells and count
1 each time it finds a specific word. So if my range of cells is
A1:A50 and the word "math" is in cells A2, A4, and A10 it would bring
back a count of 3.


All help is greatly appreciated.- Hide quoted text -


- Show quoted text -


Thank you!!!