I think you are asking for a function to tell you a row number(either the last used row OR the next available row)??

I use either =Count(range) OR =Counta(range)

In your example sheet, it would look like =COUNTA(C9:D33)+8 8 is the row offset.