Counting

  • Thread starter Thread starter Reen
  • Start date Start date
R

Reen

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?
 
Hi,

I'm not to sure you've described the question fully but you could try this.
Alt +F11 to open VB editor. Double click 'This Workbook' and paste this in
on the right

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Range("A1").Value = ActiveSheet.UsedRange.Rows.Count
End Sub

Change A1 to wherever you want the count to be

Mike
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Tuesday 1
Counting number of items excluding duplicates. 1
Count Names 2
Why doesn't excel count function update automatically? 1
Pivot tables - counting unique numbers 2
Excel is not counting 3
Count cells every 12th column 6

Back
Top