stop automatically changing formula!

  • Thread starter Thread starter caryn
  • Start date Start date
C

caryn

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.
 
Caryn,

=COUNTIF(Locking!$I$16:$I$40,"f")
or
=COUNTIF(Locking!$I16:$I40,"f")

HTH,
Bernie
MS Excel MVP
 
The $ signs in Bernie's example will lock the Row/Column references, and can
be used in any combination you like, locking down just Row or just Column or
both.
 
Back
Top