# SUM formula for future created sheets

1. ## SUM formula for future created sheets

Hi.
I am currently building an Excel workbook with sheets where I enter data from different customers. I have one "main page" where I want to continually have a summary of specific input from all my sheets (e.g. customer name x, customer name y etc.).

I understand how to make a simple sum function to summarize data from my current sheets, but is it possible to make a formula/function to include all future created sheets if all variables have a fixed placement in each sheet? (e.g. if I always summarize data from cell B4 etc.)

Attached is a sample workbook where I try to explain. Hope that helped.

Hope my question made sense and that someone know the answer to this.
Thank you.

2. ## Re: SUM formula for future created sheets

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

3. ## Re: SUM formula for future created sheets

e.g. like that:

=INDIRECT(C26&"!"&D26)
D26 contains eg =B9 the fixed cell in the relevant sheet(s) which you would like to use
C26 contains =''Sheet1' (note the double apostrophe at the beginning)

You can then wrap a sum function around indirect or whatever you wish to do
Maybe wrap an iferror around, too for as long as the new sheet doesn't exist yet

btw - there's also ways that you can determine the sheetname of any newly added sheets automatically once you add it but it might involve some Excel 4.0 Macros I believe

4. ## Re: SUM formula for future created sheets

Hi,
Thanks for the help!

6. ## Re: SUM formula for future created sheets

I did it now Still new and could not find the solved button!

There are currently 1 users browsing this thread. (0 members and 1 guests)