Fill Down Problem

  • Thread starter Thread starter scwilly
  • Start date Start date
S

scwilly

I'm hoping you guys can help me out. I have a basic formula in cell C2 I
want to copy the formula down in the cells below.

The problem is that when I click the small black box in the corner of
the cell to fill down the same number appears and not the result of the
adjacent data.

Here is the problem illustrated:

2 2 4 2 2 SUM(A1,B1)
2 5 4 2 5 SUM(A2,B2)
1 7 4 1 7 SUM(A3,B3)
3 1 4 3 1 SUM(A4,B4)

It is clear that 4 is not the sum of the rows below the first one, how
can I get Excel to return the correct value instead of dropping the
same number in everytime I try to fill down with the black square in
the corner of the cell? Thanks!!
 
You might check if:

<Tools> <Options> <Calculation> tab,

Has "Automatic" *CHECKED*

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
scwilly said:
I'm hoping you guys can help me out. I have a basic formula in cell C2
want to copy the formula down in the cells below.

The problem is that when I click the small black box in the corner o
the cell to fill down the same number appears and not the result of th
adjacent data.

Here is the problem illustrated:

2 2 SUM(A1,B1)
2 5 SUM(A2,B2)
1 7 SUM(A3,B3)
3 1 SUM(A4,B4)

It is clear that 4 is not the sum of the rows below the first one, ho
can I get Excel to return the correct value instead of dropping th
same number in everytime I try to fill down with the black square i
the corner of the cell? Thanks!!
Hi,
Are you using an = sign in front of SUM
IE:
=SUM(A1,B1)
Thx
Dav
 
Back
Top