Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I insert a counter?
I would like to keep a count on the amount of entries in a worksheet.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Day counter | Excel Discussion (Misc queries) | |||
how insert printed pages counter | Excel Worksheet Functions | |||
insert row counter | Excel Discussion (Misc queries) | |||
Need to insert a counter for supplies ordering. | Excel Worksheet Functions | |||
counter | Excel Discussion (Misc queries) |