Hello Experts,

I use following function:-

=COUNTIF(FUL!CE10:CE993,11)+COUNTIF(FUL!CE10:CE993,111)+COUNTIF(FUL!CE10:CE993,1111)

When I insert in worksheet "Ful!" at row no 10, the above function (which is in different sheet) shows cell value as CE11 instead CE10

I tried locking $CG$10 but it did not work

Any guidance?
Thanks
Karnik