How to sum cells from different sheets?
I have six sheets with numbers in each cell. I want to make a 'TOTAL' sheet that sums up each corresponding cell in each of the six sheets. For example, sum the A1 cell in Sheet 1, 2, 3, 4, 5, 6. And then sum the A2 cell in Sheet 1, 2, 3, 4, 5, 6. Basically the A1 cell in the TOTAL sheet should be the sum of Sheet 1, 2, 3, 4, 5, 6. I don't know how to do this in Smartsheet. In Excel, I can drag the formula down and it automatically applies the sum formula to each cell.
Answers
-
Sine you have 6 different sheets, I would suggest doing this by creating a Report.
As long as all 6 of your sheets have the same column names, you'll be able to use the Summary function in a Report to automatically SUM all the rows in one column across all your sheets together.
If you're looking to SUM together each cell though, versus a whole column, you would want to add an Auto-Number column to each of your 6 sheets. Then once each of the rows have a number, you can use the GROUP feature in a Report to Group together all Row 1s across the 6 sheets and Summarize by this grouping. Does that make sense?
See: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!