AutoSum multiple Cells across multiple tabs

[webdelaney]

I am trying to add multiple cells across 15 different tabs I have. When I click on the autosum main cell where I want to final number to populate, I then go to tab #1 and click on the cells I want. I then move to the next tab to click on another set of cells I want added, but since the cells are located in the same spot throughout all my tabs, its already high lighted, but will only take one set of cells. How do I compile all the cells I want to add throughout the 15 different tabs?


So example: I want my autosum to compile on tab/page#1 on Cell "I9"
I want to autosum the cells: C24,D24,E24 on tab/page2, C24,D24,E24 on tab/page3, C24,D24,E24 on tab/page4, ... etc through tab/page 15

Any help would be greatly appreciated.

Thanks,

Delaney

[Paul]

Hi Delaney, welcome to the forum.

Try:

=SUM(Sheet1:Sheet3!C24:E24)

This will sum cells C24, D24 and E24 on all sheet tabs physically located between Sheet1 and Sheet3 (including Sheet1 and Sheet3) on your sheet tab bar.

[webdelaney]

Thank you for the quick response. I have 28 total sheets, or tabs.
On tab/sheet one is where I will collect my data. So I tried what you said with a slight alteration.

inside cell: "I9" on sheet/tab one where I want to compile my numbers I pasted what you wrote, but altered it to include the sheets 2-27
=SUM(Sheet2:Sheet27!C24:E24)

when I entered that: it puts a 0 in that place but automatically opens up an UPDATE VALUES: SHEET 27 box.
It wants to to find a file?? to open? Which I have no idea where to look. If I cancel or just open up my original excel file, inside cell "I9" it says #NAME?

So not sure what that means or what I did wrong. Any suggestions with that?

Thanks again.
Delaney

[Paul]

Normally you would only get a prompt like that if you didn't actually have a sheet named "Sheet27". Is your sheet named exactly "Sheet27", or is there a space? If you have spaces between the Sheet and #, you might try:

=SUM('Sheet 1:Sheet 27'!C24:E24)

If that still doesn't fix it, try uploading your workbook.

[webdelaney]

Thank you Paul for your help. What you supplied worked.

~Delaney

[GHONDA]

What If you have individual names for the tabs, how do I enter them into the equation?

[GHONDA]

I also should add there are 96 worksheets

[FDibbins]

GHODA, Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.