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.