How do I copy a formula of "COUNTA" for a range to the next row in which the
row no is jumping to row 50?
For example, i want to count the no appear in the other sheet where
=counta(abc!c1:c10) and returns value is 2. However when i copy the formula
to the next row of the same sheet, the formula will be read as
=counta(abc!c2:c11) but what i want is =counta(abc!c61:c70).

Thanks