S
Steve Simons
Hi
I have seen how to use subtotal to count or sum filtered data, which
is great, but I can't find the answer to what I need to do:-
I have filtered data. Let's say in column A I have departments listed,
with 20 occurences of the department "Accounts". When I filter the
data on another field (say column B, the "Gender" column, looking for
only Females who work at the company), only 15 occurrences of
"Accounts" are visible.
I need to be able to count only the VISIBLE occurences of "Accounts"
(i.e. 15 of them) within the filtered data. If I use subtotal for this
I get 20 returned, when the answer should be 15.
How can I get it to show me the 15 visible records "Accounts" for this
data, filtered on Gender of "Female" ??
TIA
Steve
I have seen how to use subtotal to count or sum filtered data, which
is great, but I can't find the answer to what I need to do:-
I have filtered data. Let's say in column A I have departments listed,
with 20 occurences of the department "Accounts". When I filter the
data on another field (say column B, the "Gender" column, looking for
only Females who work at the company), only 15 occurrences of
"Accounts" are visible.
I need to be able to count only the VISIBLE occurences of "Accounts"
(i.e. 15 of them) within the filtered data. If I use subtotal for this
I get 20 returned, when the answer should be 15.
How can I get it to show me the 15 visible records "Accounts" for this
data, filtered on Gender of "Female" ??
TIA
Steve