Microsoft Excel 2003 Functions and Formulas
Formula to Sum Up All Values in Column
Summary: Quickly calculate the summed value of all cells in a column of a Microsoft Excel 2003 spreadsheet.
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.
Add: 
Del.icio.us | 
Digg | 
Furl | 
My Yahoo!
Last Modified on: July 13, 2008, at 12:04 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
Search the Site: