I am using a simple formula such as this: =COUNTA(Sheet1!D2:D20)
The problem is that anytime a row is deleted from 1 to 20, the formula adjusts itself. How do I prevent this from happening? I have been tinkering with the INDIRECT function but have had no luck making it work. Thanks!