Sum Entire Column in LibreOffice Calc

Technical Information Type: 
Fix
Environment: 
LibreOffice 3.4.5 in openSUSE 11.4 x86_64
Problem: 

I wanted to total the dollar amounts in an entire column of a spreadsheet, with the sum preferably appearing on a different sheet in the file. The seemingly-obvious SUM(A) to sum all values in column A did not work.

Status: 
Fixed
The Fix: 

To achieve this, a data range needs to be defined for the column in question. For this example, we'll assume it's column C on Sheet2.

  1. Go to the sheet with the column of data (e.g., click the "Sheet2" sheet's tab)
  2. Click the column header (i.e., "C" — not a text header you've added)
  3. Click the "Data" menu and choose the "Define Range..." option
  4. In the dialog that appears, give the range a name (e.g., "MyMoney")
  5. Go to the sheet where you want the total to appear
  6. In the cell where you want the sum to appear, use SUM() with the name of the data range, like: SUM(MyMoney)
Fix License: 
Creative Commons: Attribution-ShareAlike