result column


K

Khht

I have 3 columns lets call them a,b and c.
line 1 column C I have a total amount
line 2 I have amounts in colum a and b and want a new total in column C
2c=(1c+2a+2b)
than:
3c= (2c+3a+3b), etc.
is there somehow I can set that up to calculate automatically through a
macro??
 
Ad

Advertisements

J

JLatham

I'm not exactly sure of what you want or expect a macro to do. Your formula
can be filled down easily as new rows are added to the sheet.

Formulas:
in C1: =A1+B1
in C2: =C1 + A2 + B2
from this point if you just copy/fill the formula in column C on down the
sheet it will automatically add the contents of column C 1 row above the
formula to the contents of A and B on the same row.

What is you want a macro to do: and when would it do it?
 

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

Top