title: How to count rows in excel by using text
body: <p>I am trying to count the total rows of in a section of an excel sheet. My problem is that my formula needs to account for rows being added and removed both in the section and above the section. Using functions =ROWS(A14:A20) and =ROWS(INDIRECT("A14:A"&amp;ROW()-1)) won't work because if I add a row under row A8 now my function needs to be A15:A21. I have text in both the top and bottom rows that will always be consistent, is there a way to write a function using the text as a start and stopping point for my row count?</p>