View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Counting Specific Text

Maybe

=COUNTIF(A1:A50,"math")

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"japc90" wrote in message ...
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.