How to use the Sum function in Excel or Google Spreadsheet to perform a sum of numbers and end with the cell above the location of the total
Sum of Rows in Excel
| A | B | |
| 1 | Day | Sales Total |
| 2 | Monday | $1,325.47 |
| 3 | Tuesday | $1,502.69 |
| 4 | Wednesday | $1,452.14 |
| 5 | Thursday | $1,398.85 |
| 6 | Total | $5,679.15 |
=SUM(B2:OFFSET(B6,-1,0))
Excel Source: SUM OFFSET Formula
Sum of Rows in Google Spreadsheet
| A | B | |
| 1 | Day | Sales Total |
| 2 | Monday | $1,325.47 |
| 3 | Tuesday | $1,502.69 |
| 4 | Wednesday | $1,452.14 |
| 5 | Thursday | $1,398.85 |
| 6 | Total | $5,679.15 |
=SUM(INDIRECT(“B2:”&ADDRESS(ROW()-1,COLUMN(),4)))
Google Spreadsheet Source: SUM OFFSET Formula