Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count certain records in filtered data
Hi
I have seen from looking through this NG how to use subtotal to count or sum filtered data, which is great, but I've been hunting around for nearly an hour to find the answer to what I need to do. I'm sure it can't be too difficult, but I'm having a one of dem days . . . I have filtered data, let's say in column A I have departments listed, with 20 occurences of dept "Accounts". When I filter the data on another field only 15 occurrences of "Accounts" are visible. I need to be able to count (and and also sum) the number of occurences of "Accounts" within the filtered data. If I use subtotal for this I get 20 returned. TIA Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import filtered data | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
How can the count of filtered records always display? | Excel Worksheet Functions |