Copy Formula Down Without Changing Entire Formula

[roy.okinawa]

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

I want to copy it down but do not want the D81000 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]

=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]

Dave,

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

Thank you.

 

[George]

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$1000 Fixed Rows
$D$8:$D$1000 Fixed Row & Columns

George