Re: stop automatically changing formula!

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"caryn" <caryn.tan@xxxxxxxxx> wrote in message
news:d7n4u3$hgi$1@xxxxxxxxxxxxxxxxxxxxxx
> 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.
>
>


.

Loading