Put a $ before each I, making the columns absolute

=COUNTIF(Locking!$I16:$I40,"f")

If you enter this formula by pointing at cells, pressing the F4 key will
cycle you through absolute rows & columns, absolute rows & relative columns,
relative rows & absolute columns, and completely relative.

Check Help to find out about absolute & relative addresses


"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?!?!?!
thanks.