Hello,
I'm not experienced with Excel, and I have a question. I have a form and there is drop down boxes to sort various information. Its an attendance form, and for instance we can sort to just show Wednesday, etc. Well when we want to average out totals for just a Wednesday, Excel sees all the other data for every other day as well. Is there a way to fix this? Thanks.
Please Login or Register to view this content.
You can perform functions on filtered ranges using the Subtotal Function.
Average would be:
=SUBTOTAL(1,A1:A10)
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
davegugg is, of course, correct. I was assuming you wanted to have your averages work regardless of what's filtered. Both methods work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks