Fixed vlaue in the Fill handle opperation

B

BrusPB

Hi
I have this formula in Cell A3:
sum(A1+A2)

I want to fill handle this cell and have the cell A4 as below:
sum(A1+A3)

As you see, the A1 must be fixed. But this operation makes the A4 as below:
sum(A2+A3) which is not my aim.

Thnx 4 any reply.
 
R

Rick Rothstein \(MVP - VB\)

I have this formula in Cell A3:
sum(A1+A2)

I want to fill handle this cell and have the cell A4 as below:
sum(A1+A3)

As you see, the A1 must be fixed. But this operation makes the A4 as
below:
sum(A2+A3) which is not my aim.
Click to expand...

You can use an absolute reference for A1...

=SUM(A$1+A2)

Rick
 
D

Dave Peterson

Or just
=A$1+A2

Hi
I have this formula in Cell A3:
sum(A1+A2)

I want to fill handle this cell and have the cell A4 as below:
sum(A1+A3)

As you see, the A1 must be fixed. But this operation makes the A4 as below:
sum(A2+A3) which is not my aim.

Thnx 4 any reply.
Click to expand...
 
Top