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