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. I can do that easy enough at the start, by putting an '1 in the first cell / row I want counted and then dragging it down. However, doing it that way, if I delete row 4, then my overall count doesn't update, row 5 is still row 5, when now it should be the new row 4.

What I would like, is a way for the row numbers to update automatically when delete a row, instead of having to manually redo the row numbers.

Any help would be greatly appreciated.

Thanks.