I came across what I consider to be a very useful formula recently. SUBTOTAL. I have used it to count entries in a large database which has filters.
It allows for a quick answer to a request for breakdowns of the data no matter how many filters are applied as long as there are entries in each cell of the chosen range.
I've attached a small example with explanations which I hope will be helpful.
Last edited by Paul; 01-11-2013 at 03:39 PM.
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
Thanks. I just found this the other day as well. Very nice for filtered data.
You can also use the subtotal Formula for "Sum" or averages, etc. It works great
It's a very useful function. The Excel Help files and Microsoft's website can provide more detail on its usage.
http://office.microsoft.com/en-us/ex...010062463.aspx
if you have 2010 AGGREGATE is even better
yes, it's useful
Great, its very useful i can use this in my project..
- Thiru
Very very useful "Indeed". Thanks! I'm lovin my engagment with Excel Help Forum Members! Kudos to everyone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks