Try this idea from a recent positng of mine where a, b,c are names of
worksheets and a2 is what you are looking for and a1:h10 is the search area

=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"b","c","d","e"} &"'!a1:h10"),A2))


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jafarz" wrote in message
...
Is there a way to search an entire multiple sheet spreadsheet for a
particular text string, count how many times it occurs and return the sum
of
the total number of times the text occurs?