How do I insert a counter?

  • Thread starter Thread starter DianeBrew
  • Start date Start date
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
 
I would like to keep a count on the amount of entries in a worksheet.
Click to expand...

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
 
Back
Top