How do I insert a counter?
 

I would like to keep a count on the amount of entries in a worksheet.

How do I insert a counter?
 

To count the number of non-empty cells in column A:

=COUNTA(A:A)

--
Biff
Microsoft Excel MVP


"DianeBrew" wrote in message
...
I would like to keep a count on the amount of entries in a worksheet.

How do I insert a counter?
 

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
"DianeBrew" wrote in message
...
I would like to keep a count on the amount of entries in a worksheet.

How do I insert a counter?
 

On Aug 17, 6:36 pm, DianeBrew
wrote:
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