Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Misc
Count certain records in filtered data
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Steve Simons, post: 9069499"] 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 [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Misc
Count certain records in filtered data
Top
