I have used
COUNTIFS() formula in Google Sheet. Whenever I insert a new row in the worksheet the range of the
COUNTIFS formula gets updated.
For e.g if my formula is
and I insert one row the formula will become
As such the newly inserted row is outside the range of
COUNTIFS() formula and I get an undesired result.
I have tried appending
$ to the column part of the range to lock but it didn't work i.e.
Could you suggest a way to lock the range
Detail!C2:C10 regardless of how many rows are newly added.