Thread: Counting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default 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?