I have a formula "=COUNTIFS(D2:D1000,">=11/1/2018",D2:D1000,"<=11/30/2018")" I use this to count dates of interviews. One problem I'm having is that as I finish an interview I move the row to another excel page and delete it from the page it was on. As I delete rows the range of my formula gets smaller. After a month of adding and moving rows, the formula range decreases to around D2:D55. How can I make my formula stay D2:D1000 even when I delete rows within that range?
Solved by B. Y. in 14 mins