B
BeSmart
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)
Also, if a worksheet name has a space in the name how does that look in the
formula: 'Sheet 1'Blank5!A:A
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)
Also, if a worksheet name has a space in the name how does that look in the
formula: 'Sheet 1'Blank5!A:A