thesilkworm
New Member
- Joined
- Jan 5, 2014
- Messages
- 23
Hi,
I have a workbook to which I am adding a single sheet every week. These weekly sheets will just be named "1", "2", "3", etc.
I also have a summary sheet which I want to display year-to-date totals. The trouble is, the formula which will work at the end of the year (referencing all 53 weekly sheets), is referencing sheets which do not yet exist.
Is there any way to make, for example, the following simplified formula work properly if sheets "1" and "2" do exist, but "3" does not exist:
='1'!A1+'2'!A1+'3'!A1
I want it to ignore the reference to sheet '3' and just give me the results from the first 2 sheets. I have tried IFERROR('3'!A1,0) instead of '3'!A1, but even this just asks me which sheet I am referencing.
Does anyone have any ideas? Thanks for any help.
I have a workbook to which I am adding a single sheet every week. These weekly sheets will just be named "1", "2", "3", etc.
I also have a summary sheet which I want to display year-to-date totals. The trouble is, the formula which will work at the end of the year (referencing all 53 weekly sheets), is referencing sheets which do not yet exist.
Is there any way to make, for example, the following simplified formula work properly if sheets "1" and "2" do exist, but "3" does not exist:
='1'!A1+'2'!A1+'3'!A1
I want it to ignore the reference to sheet '3' and just give me the results from the first 2 sheets. I have tried IFERROR('3'!A1,0) instead of '3'!A1, but even this just asks me which sheet I am referencing.
Does anyone have any ideas? Thanks for any help.