I realised this straight-after posting, but thought, what the heck, the
statement is true even if it doesn't apply here :-)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Biff" wrote in message
...
Note that SUMPRODUCT doesn't work with complete
columns, you have to specify a range.

True, but in this case Sumproduct wouldn't be referencing the entire
columns, Sumif would:


=SUMPRODUCT(SUMIF(INDIRECT("'"&C1:C3&"'!A:A"),"val ue",INDIRECT("'"&C1:C3&"'!
B:B")))

Biff

"Bob Phillips" wrote in message
...

=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