Skip to content

Sum of Rows

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

AB
1DaySales Total
2Monday$1,325.47
3Tuesday$1,502.69
4Wednesday$1,452.14
5Thursday$1,398.85
6Total$5,679.15

=SUM(B2:OFFSET(B6,-1,0))

Excel Source: SUM OFFSET Formula

 

Sum of Rows in Google Spreadsheet

AB
1DaySales Total
2Monday$1,325.47
3Tuesday$1,502.69
4Wednesday$1,452.14
5Thursday$1,398.85
6Total$5,679.15

=SUM(INDIRECT(“B2:”&ADDRESS(ROW()-1,COLUMN(),4)))

Google Spreadsheet Source: SUM OFFSET Formula