Excel 2007 : counting rows

Originally Posted by runnymede15june1215

Thanks, but that does add up the total rows I have, but that's not what I need. Let me rephase my question:

I want each row to have a unique number.

His formula does exactly what you asked...try it, see example attached

Deleted a few rows out of this example...they automatically renumber themselves