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

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.