Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REPOST: Count certain records in filtered data
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I COUNT CELLS WITH DATA BY COLUMN? | Excel Worksheet Functions | |||
count specific value with filtered data | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Copying filtered data to another Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions |