adding columns

[autumn]

Help, how do I just add a column to gain the total. Thanks

 

[Paul B]

autumn, something like, =SUM(A1:A10), to add whats in A1:A10

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Domenic]

You can use the SUM function...

=SUM(A1:A100)

Adjust the range accordingly.

Hope this helps!

 

[Paul B]

Or for the whole column, =SUM(A:A)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[autumn]

I guess I was making it too complicated. Thanks

You can use the SUM function...

=SUM(A1:A100)

Adjust the range accordingly.

Hope this helps!

 

[Ames]

Why doesn't any part of the "help" section say you have to start at the
bottom and go up- You have to start highlighting the cells where you want
your total to be, and stop at the cell before where you want to stop. It
just took me 3 hours to figure this out. Who the heck designed this????

 

[Gord Dibben]

What are you doing? AutoSumming a column of numbers?

You definitely won't find that in help because it sounds like you're doing
it backwards.

If using AutoSum, just select the top cell then drag down untill you get to
last cell and hit the AutoSum Icon.


Gord Dibben MS Excel MVP