 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Filters
Hello, I have filtered a large list and am just trying to count my filtered results. When I put the function "count" in, it counts the hidden rows or filtered out rows along with my filtered results. How do I just get the total number of my filtered results? If anyone can help please email me at ckanstrup@accumepartners.com or kanstrup@gmail.com. I am not looking for a dollar figure of my results but just the total number of items that my filter produced. Thank you, Chris Look in the help index for SUBTOTAL  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Hello, > I have filtered a large list and am just trying to count my filtered [quoted text clipped - 10 lines] > Thank you, > Chris I have but unfortunately it still counts the rows that I filtered out. Any other ideas? > Look in the help index for SUBTOTAL > [quoted text clipped - 12 lines] > > Thank you, > > Chris That is not possible, use =SUBTOTAL(3,A2:A1000) where A2:A1000 is the whole range of the list/table you filter SignatureRegards, Peo Sjoblom >I have but unfortunately it still counts the rows that I filtered out. Any > other ideas? [quoted text clipped - 19 lines] >> > Thank you, >> > Chris Hello, Thank you for your help. It worked. I was using =subtotal(9,A2:A1000) What is the difference between 3 and 9 in these formulas? I tried looking it up and don't understand what they are saying? If you can answer, I would greatly appreciate it. If you could copy me at ckanstrup@accumepartners.com that would be great too. Thanks, Chris > That is not possible, use > [quoted text clipped - 25 lines] > >> > Thank you, > >> > Chris 9 will SUM, 3 will count all entries (text as well as numbers) 2 will count numbers only There are other things like average etc. If you look up subtotal in help you'll see what the numbers mean SignatureRegards, Peo Sjoblom > Hello, > Thank you for your help. It worked. I was using [quoted text clipped - 45 lines] >> >> > Thank you, >> >> > Chris |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.