Relative reference for Countif

Hello Experts,

I have to insert row and update data in B10 from sheet FUL on a weekly basis and use following fuction in another sheet
When I insert row in sheet "Ful"; cell B10 show as B11 where fucntion is used. I have to change manually to B10

I have used $B$10 but still unable.

Any suggestions?

=COUNTIF(FUL!B10:F3568, 2)

Thanks
Karnik

Try

=COUNTIF(INDEX(FUL!B:B,10):FUL!F3568,2)

Thanks Cutter,
It worked brilliantly!
Saved lot of my time...
Cheers (with coffee!!)
Karnik

Glad to hear it, and you're welcome. Thanks for the feedback.