S
Stiggy
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?
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?