How to sum cells from different sheets?

Devika_Renewables

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.

Genevieve P.

Hi @Devika_Renewables

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