View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
japc90 japc90 is offline
external usenet poster
 
Posts: 58
Default Count fowmula that will look for multiple words

I want to type a formula that will look at a range of cells and
count
1 each time it finds any of a list of words. So if my range of cells
is
A1:A50 and the word "math" is in cells A2 and A4 and the word
"science" is in cells A5 and A10 it would bring back a count of 4.

All help is greatly appreciated.