Copy Formula Down Without Changing Entire Formula
 

I have this formula: =COUNTIF(Overall!D8:D1000,A15)

I want to copy it down but do not want the D8:D1000 to change. That is the
range that is being looked at on the other worhsheet. The only thing that
should change is the A15. It will change to A16, A17, etc. as it is copied
down.

Help.

Copy Formula Down Without Changing Entire Formula
 

=COUNTIF(Overall!$D$8:$D$1000,A15)

The $ signs tell excel not to change that address when you copy/move the
formula.

The $d means you can drag right or left and no change will happen
the $8 (and $1000) means that these won't change if you drag up or down.



roy.okinawa wrote:

I have this formula: =COUNTIF(Overall!D8:D1000,A15)

I want to copy it down but do not want the D8:D1000 to change. That is the
range that is being looked at on the other worhsheet. The only thing that
should change is the A15. It will change to A16, A17, etc. as it is copied
down.

Help.



--

Dave Peterson

Copy Formula Down Without Changing Entire Formula
 

Dave,

That did it. Now I know what the $ sign means.

Thank you.

"Dave Peterson" wrote:

=COUNTIF(Overall!$D$8:$D$1000,A15)

The $ signs tell excel not to change that address when you copy/move the
formula.

The $d means you can drag right or left and no change will happen
the $8 (and $1000) means that these won't change if you drag up or down.



roy.okinawa wrote:

I have this formula: =COUNTIF(Overall!D8:D1000,A15)

I want to copy it down but do not want the D8:D1000 to change. That is the
range that is being looked at on the other worhsheet. The only thing that
should change is the A15. It will change to A16, A17, etc. as it is copied
down.

Help.



--

Dave Peterson

Copy Formula Down Without Changing Entire Formula
 

It's called absolute addressing (refer help)
Just use $ sign in front of row, column or both to keep it fixed
eg. $D8:$D1000 Fixed Column
D$8:D$1000 Fixed Rows
$D$8:$D$1000 Fixed Row & Columns

George

roy.okinawa wrote:
I have this formula: =COUNTIF(Overall!D8:D1000,A15)

I want to copy it down but do not want the D8:D1000 to change. That is the
range that is being looked at on the other worhsheet. The only thing that
should change is the A15. It will change to A16, A17, etc. as it is copied
down.

Help.