Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a filtered list of data where one column contains either of two text
values say "A" or "B". When using filters on other columns I would like to att a counter above the list that always show the number of "A" and "B" rows in the filtered data. I do not want to add additional columns. I cannot use Countif() since that doesnt bother about the filters. If I use subtotal(3;...) it cares about the filters, but then I can only get the sum of rows containing "A"'s and "B"'s... Is this at all possible to achieve without macros or custom functions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do make a "Top seller" list in excel? | Excel Discussion (Misc queries) | |||
Make Excel 2000 print long narrow list "snake" on wide paper? | Excel Discussion (Misc queries) | |||
how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
Make typing "jump" to matching item(s) in drop-down list? | Excel Discussion (Misc queries) |