Count text in cells?

  • Thread starter Thread starter hoyos
  • Start date Start date
H

hoyos

How can I modify the formula below so that it counts the word "Search"

=SUMPRODUCT(--(Date1>=Orders!$H$3),--(Date1<=Orders!$I$3),--(Purpose=A2))
 
Since you are using named ranges this will be a general formula...

=SUMPRODUCT(--(Date1>=Orders!$H$3),--(Date1<=Orders!$I$3),--(Purpose=A2),
--(isnumber(Search("Search", C1:C10))))

Check out the previously supplied link for more info...
 
Thanks Jim,
I was looking at the link but getting in a muddle!!!
I used your formula and modified it alittle and came up with this:

=SUMPRODUCT(--(Date1>=Orders!$H$3),--(Date1<=Orders!$I$3),--(ISNUMBER(SEARCH("Search", Purpose))))

It works well.
Thanks once again.
 
Back
Top