Dears,
I'm looking for a way to include SUM for a non existent sheet so I can avoid the #Ref error. This is for Excel 2010.
Something along the lines of =IF(ISREF(INDIRECT("'7999'!E2"));INDIRECT("'7999'!E2");""); but with SUM added for E:E for a specific sheet.
How would I go on about this?
Thanks and Regards.
Maybe
=SUM(IFERROR(formula,0),IFERROR(formula,0)...)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Not sure if this will be of any assistance, but if you add a blank worksheet at the start and end of your data sheets, and call them Start and End, then when you enter your calcs, you could just enter =sum('start:End'!C12) or whatever your references are. this way, you can add or remove sheets as needed, and it will add across all the sheets you need it to, and keep the totals as the data sheets change. make sure your "Master" sheet is before the Start sheet though
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks