Count text in cells?

[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))

 

[Jim Thomlinson]

Since you have not told us which column will contain the word search...

http://www.xldynamic.com/source/xld.SUMPRODUCT Part 2.html#partial

 

[hoyos]

Appologies Jim
It's column "C"

Since you have not told us which column will contain the word search...

http://www.xldynamic.com/source/xld.SUMPRODUCT Part 2.html#partial

 

[Jim Thomlinson]

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...

 

[hoyos]

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.