Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

Excel 2013: Is there a function that does a 'Sum cell A3 for ALL tabs except for one'?

Hello Excel Rock Stars

I have a client/buddy that wants to do thirty tabs for thirty different events, all with the same format.

The end will have a 'Totals' tab, where I need to sum cells from all 30 other tabs, e.g. Sum(all a3's except for the Totals tab), Sum(all b4's except for the Totals tab), etc.

Is that possible?

Thanks.
Jimbo
0
Jim Horn
Asked:
Jim Horn
1 Solution
 
Chris MillardCommented:
Ok, lets assume the workbook has 31 sheets (tabs) called "Event1" "Event2" .... "Event30" "Event Totals" etc

In cell A3 on sheet "Event Totals" you would type

Sum(Event1:Event30!A3)
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Bingo bango.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now