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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!