=SUMPRODUCT(SUMIF(INDIRECT("'"&C1:C3&"'!A:A1000"), "value",INDIRECT("'"&C1:C3
&"'!B1:B100")))

where all the sheets are listed in C1:C3, or however many are needed.

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"BeSmart" wrote in message
...
Hi
Why is this formula not working?

I want to sumif column A across a range of worksheets (hopefully if a
worksheet is added within the range of worksheets, the totals of the new
worksheet will be automatically included via this range).

=SUMIF(Sheet1:Blank5!A:A,ALL!A14,Sheet1:Blank5!D:D )

Also, if a worksheet name has a space in the name how does that look in
the
formula: 'Sheet 1'Blank5!A:A

--
Thank for your help
BeSmart