Thanks for the response Bob & Biff - but I'm getting a #REF on the formula
you suggested. I think it's because the formula is trying to include my
totals sheet which is called "All". That's where I'm using this formula to
calculate and report the totals of all the other sheets in the workbook.

I also have a DATA sheet that can't be included in the totals.
How do I exclude the ALL sheet and DATA sheet in the formula?

I didn't understand why C1:C3 and B1:B3 were nominated in your solution as
my original formula only looked at column A and column D?

So what I'm needing it to specifically look at is column A1:A300 on all
sheets (except DATA and ALL) where the word "SEARCH" appears. If SEARCH is
found I need the equivalent figures in D1:D300 to be summed.

This is the formula I've put in at the moment:

=SUMPRODUCT(SUMIF(INDIRECT("'"&A1:A300&"'!A:A"),"S earch",INDIRECT("'"&A1:A300&"'!d:d")))

Sorry for my ignorance, I'm a novice at these formulas and am learning as I
go...
--
Thank for your help
BeSmart