G
Guest
Help, how do I just add a column to gain the total. Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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
--
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
D
Domenic
You can use the SUM function...
=SUM(A1:A100)
Adjust the range accordingly.
Hope this helps!
=SUM(A1:A100)
Adjust the range accordingly.
Hope this helps!
P
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
--
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
G
Guest
I guess I was making it too complicated. Thanks
Domenic said:You can use the SUM function...
=SUM(A1:A100)
Adjust the range accordingly.
Hope this helps!
A
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????
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????
G
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
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