Automatically adding extra cell

Hi All

I have a formula issue. I will give an example of what I want to do

Say I have 59 in A1,B1,C1,D1 and so on

In A2 I have put =SUM(A1), now in B2 i want it to be =SUM(A1+B1). That bits simple. But for C2 I would want it to add A1,B1 and C1.

How could I do this so I just have to put the formula in B1 then drag it accross the rest of the row?

Regards

Aarron

Hi Stenner,

Enter this in A2:

Formula:

Please Login or Register  to view this content.

Then drag across. FYI to automatically enter the dollar sign, press F4 in the formula bar!

Regards,

J.

remember to add rep

Hi Ford

Unfortunatly it didnt work.

Cell C2 would need to be A1:B1:C1 but it just says A1:C1.

Regards

Aarron

Hi James

Same thing happended as what Ford said to do

Originally Posted by Stenner

Hi James

Same thing happended as what Ford said to do

I think you are missunderstanding the use of a colon in excel.

To sum ONLY A1 & C1 you would use the following:

Formula:

Please Login or Register  to view this content.

To sum A1 & B1 & C1 you would use the following:

Formula:

Please Login or Register  to view this content.

Regards,

J.