sum a column

using windows excel 2007

How could I sum an entire column?
LVL 1
rgb192Asked:
Who is Participating?
 
JullezConnect With a Mentor Network EngineerCommented:
You can get the column total by clicking Sum Button image in the Editing group on the Home tab. This enters the SUM function, which adds up all the values in a range of cells.

Here is an example: http://office.microsoft.com/en-us/excel-help/get-to-know-excel-2007-enter-formulas-RZ010074593.aspx?section=5
0
 
AlanConnect With a Mentor ConsultantCommented:
To sum column A:

=SUM(A:A)

If column A contains any cells that are text, it will be ignored.

If column A contains any cells that have 'errors' (such as a divide by zero error - #DIV/0! or a 'not applicable' - #N/A) then the sum will error too until you resolve or remove them.

HTH,

Alan.
0
 
Mahesh BhutkarConnect With a Mentor Commented:
At the end of column just give the expression
=SUM(firstcell : lastcell)
0
 
SteveConnect With a Mentor Commented:
Another useful method of Summing the whole Column can be SUBTOTAL

=SUBTOTAL(9,A:A) will sum column A in much the same way as SUM

=SUBTOTAL(109,A:A) will sum column A on Visible cells only (so hidden rows will be excluded from the sum.
0
 
rgb192Author Commented:
Sum button is easiest.
Thanks.
0
All Courses

From novice to tech pro — start learning today.