D
DianeBrew
I would like to keep a count on the amount of entries in a worksheet.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
To count the number of non-empty cells in column A:
=COUNTA(A:A)
=COUNTA(A:A)
O
Otto Moehrbach
Diane
Do you want a running count (in some cell) or do you want to count the
number of occupied cells at some point in time, say when the workbook is
saved? Otto
Do you want a running count (in some cell) or do you want to count the
number of occupied cells at some point in time, say when the workbook is
saved? Otto
M
Michael.Tarnowski
I would like to keep a count on the amount of entries in a worksheet.
Hi Diana,
you should distinguish between a filtered and unfiltered data set.
The formula
=TEXT(COUNTA(dynItemSet);"0000")&" / "&TEXT(SUBTOTAL
(3;dynItemSet);"0000")
gives you by COUNT a counter for the unfiltered, and by SUBTOTAL a
counter for the filtered data set.
Hope that helps, have fun
Cheers
Michael