Counting
Yes.
One option is to put 1 in A1
then put this in A2
=IF(B2="","",MAX(A$1:A1)+1) and copy down
This will show a running total of rows with data in Col B
"Reen" wrote:
Is there a way to automatically count the number of entries on the spreadsheet?
Meaning a running total of rows with data entered on it?
|