Take a look at Help's "The difference between relative and absolute
references" topic.


In article ,
"caryn" wrote:

i have a countif function
COUNTIF(Locking!I16:I40,"f")
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")

How do I stop it from changing column I to J?!?!?!