This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Formula to Sum Up All Values in Column

Normally, to sum up the value of a particular column, you could use the SUM formula. For example, if you have values in column B between rows 11 and 33, you could use this SUM formula to get the total value:

=sum(b11:b33)

However, what if you keep adding values to column B? For example, if you placed a value in row 34, you would have to modify the above SUM formula to the following:

=sum(b11:b34)

This can get quite annoying. Instead, use the following shortcut to place to sum of an entire column in one cell:

=sum(COLUMN:COLUMN)

Which, in this example, would be:

=sum(b:b)

Note that you cannot place this formula in column B, else Excel 2003 shows a circular reference error. Instead, you can place this formula in any other column besides the one you are summing up.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Formula to Sum Up All Values in Column.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.