find the last item in a range and retrieve the count of rows

Hello ExcelGurus
as you can see from the image, as I said in the title i need a formula that gives me back the count of rows of a column that as more full rows.
In this case is the result is 7 because in this table the columns that as more NOT empty cell is column D

EDIT
find the last number in a range and counts how many rows has got that range
Hope is clear!

Thank you for your help!

\1

You may try something like this.....

Please Login or Register  to view this content.

You're welcome XLalbania! Glad I could help.

Thanks for the feedback as well.