Copying Formula

[musab]

I have a spreadsheet. Column A, B and C. Rows 1-10
I have numbers in A and B. In column C, I want a formula to calcutate the
sum of B+A1 in all the rows. Please help. Remember I just want the sum of
column B for A1 only.

Thanks

 

[trip_to_tokyo]

Musab, your instructions are not clear but here is a first attempt:-

1 11 12
2 12 13
3 13 14
4 14 15
5 15 16
6 16 17
7 17 18
8 18 19
9 19 20
10 20 21

1. In C1 I have:-

=(B1+$A$1)

2. In C2 I have:-

=(B2+$A$1)

3. In C3 I have:-

=(B3+$A$1)

- and so on.

Is this what you want? (I am not sure).

Please click on Yes if my comments have helped.

Thanks!

 

[Pete_UK]

Put this in C1:

=SUM(A1,B$1:B$10)

and then copy down to C10.

Hope this helps.

Pete

 

[musab]

Thats Exactly what I wanted. Thank you very much.

 

[Gord Dibben]

=$A$1+B1 to keep A1 constant as you copy down the column

Not too clear on details but post back if need something else.


Gord Dibben MS Excel MVP