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 AutoNumber 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!