How do I insert a counter?

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
 
M

Michael.Tarnowski

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
 

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

Need VBA Macro to Loop through pages and print counter in footer of each page 9
Section and Page numbering 0
Change Style to 'Keep with previous' instead of Keep with Next 1
How to count the numbers in a Word document? 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
need help on either doing a loop and counting specific values orusing subtotal function 2
How to insert Certificated digital signature in Word for Mac 0
How do I clear a form? 0

Top