add all contiguous numbers-column-row

J

JClark

Hello Group:
I have a problem. I used the AutoSum function (Capital Sigma) to total
a column, so I don't have to keep changing the sum formula when I add
extra rows. My problem is that when I get to the third column, Autosum
adds the totals of the first two rows rather than the total of the
third column. How do I tell autosum to add vertically rather than
horizontally?

Many thanks!

Jack
 
B

Bernard Liengme

Copy the formula for the second total to the right by dragging the fill
handle (small solid square in lower right of active cell)
best wishes
 
J

JClark

Copy the formula for the second total to the right by dragging the fill
handle (small solid square in lower right of active cell)
best wishes
Click to expand...
Thank you, Bernard!

Jack
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADDING NUMBERS IN A COLUMN 7
An odd problem with SUM(A:B) and AutoSum 2
Using Autosum 4
How to import numbers as numbers in excel? 2
Newbie problem: numbers with +positive and -negative indicators 9
easy one - multipule formulas in one cell 5
Total a column (or row0 by highlighting cells 1
using SUM to add up only some numbers in a column 7

Top