Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting
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 "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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting | Excel Discussion (Misc queries) | |||
counting | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |