How to add columns - 2nd request

N

Noodles

Paul B said it could be done, but not how to do it.

Need to add figures in column. What I am doing now I'm sure is the hard
way:

A B C D
1
2 15.65 15.65 =Sum C1+A2 =Sum D1+B2
3 15.44 15.44 =Sum C2+A3 =Sum D2+B3


After I get the columns totaled I then delete columns C & D etc because they
are not needed anymore. There as to be an easier way.
 
S

Sunil Jayakumar

Hi,

If you're just looking for the totals, then try;

in cell C24:
=SUM(C1:C23)+(SUM(A2:A24)
in cell d24:
=SUM(D1:D23)+(SUM(B2:B24)

This will give you totals.

Hope this helps

Warm regards

Sunil Jayakumar

Noodles said:
Paul B said it could be done, but not how to do it.

Need to add figures in column. What I am doing now I'm sure is the hard
way:

A B C
D
1
2 15.65 15.65 =Sum C1+A2 =Sum D1+B2
3 15.44 15.44 =Sum C2+A3 =Sum D2+B3


After I get the columns totaled I then delete columns C & D etc because
they
are not needed anymore. There as to be an easier way.
Click to expand...
www.ayyoo.com/credit-cards.html
 
P

PCLIVE

If I understand what you want to do,
Try this:

Right-click on column "C", or which ever column you want to insert a new
column in front of, and then select 'Insert'.

HTH,
Paul
 
G

Guest

Noodles said:
Paul B said it could be done, but not how to do it.

Need to add figures in column. What I am doing now I'm sure is the hard
way:

A B C D
1
2 15.65 15.65 =Sum C1+A2 =Sum D1+B2
3 15.44 15.44 =Sum C2+A3 =Sum D2+B3


After I get the columns totaled I then delete columns C & D etc because they
are not needed anymore. There as to be an easier way.
Click to expand...

-----------

One easier way would be to not bother deleting the working columns. Are
they hurting something by being there? Or you could just resize the
column width for C and D down to near 0 so they're still there but don't
show unless you widen them again.

If you're relying on the results of column C and D, then I personally
would never delete them. That also deletes any audit path you have to
figure out later why you've got some result that doesn't look right to you.

Good luck...

Bill
 
B

bj

If what you want is the total of the cells in Columns A and B

=sum(A1:A100) in one cell would give you the total of the data in A1to A100
and =Sum(B1:B100) for column B

If you want a different set of cells, just change the formula.
 
Top