Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

sum a column

using windows excel 2007

How could I sum an entire column?
0
rgb192
Asked:
rgb192
4 Solutions
 
JullezCommented:
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
 
AlanConsultantCommented:
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 BhutkarCommented:
At the end of column just give the expression
=SUM(firstcell : lastcell)
0
 
SteveCommented:
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now