Copying Formula

  • Thread starter Thread starter musab
  • Start date Start date
M

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
 
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!
 
=$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
 
Back
Top