Excel 2007 : counting rows

If you're satisfied with his solution click on the scales in his post and give him some credit, then go back and edit your first post in this thread to "solved.

....to mark thread as solved, choose edit button, then choose Go Advanced, scroll up to the title and change the prefix to Solved, and then choose save.