Help with Formula using a starting point

Hi,

I would be grateful for any help on this one....

A1 = 1
B1 = 2

C3 = 180

What I want to do is total A1+B1+C3 Which would be 183

The problem is each week I need to change the values of A1 and B1 but keep adding them to whatever the last value of C3 was.

EG - Next week if I had A1 = 10 and B1 = 10 then C3 would be 203, based on the previous value of 183, then 10+10

Hope this is clear

The only way I know to do it is with a worksheet change macro

Copy this macro
GoTo Excel
Select sheet this is to appy to
Right Click on Sheet Name Tab > select View Code
Past macro into the Worksheet Module displayed

Please Login or Register  to view this content.

Thanks,

Thats solved it