| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filters
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 or . 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Filters
I have but unfortunately it still counts the rows that I filtered out. Any
other ideas? "Don Guillett" wrote: Look in the help index for SUBTOTAL -- Don Guillett Microsoft MVP Excel SalesAid Software "kanstrup" wrote in message ... 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 or . 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Filters
That is not possible, use
=SUBTOTAL(3,A2:A1000) where A2:A1000 is the whole range of the list/table you filter -- Regards, Peo Sjoblom "kanstrup" wrote in message ... I have but unfortunately it still counts the rows that I filtered out. Any other ideas? "Don Guillett" wrote: Look in the help index for SUBTOTAL -- Don Guillett Microsoft MVP Excel SalesAid Software "kanstrup" wrote in message ... 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 or . 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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Filters
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 that would be great too. Thanks, Chris "Peo Sjoblom" wrote: That is not possible, use =SUBTOTAL(3,A2:A1000) where A2:A1000 is the whole range of the list/table you filter -- Regards, Peo Sjoblom "kanstrup" wrote in message ... I have but unfortunately it still counts the rows that I filtered out. Any other ideas? "Don Guillett" wrote: Look in the help index for SUBTOTAL -- Don Guillett Microsoft MVP Excel SalesAid Software "kanstrup" wrote in message ... 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 or . 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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Filters
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 -- Regards, Peo Sjoblom "kanstrup" wrote in message ... 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 that would be great too. Thanks, Chris "Peo Sjoblom" wrote: That is not possible, use =SUBTOTAL(3,A2:A1000) where A2:A1000 is the whole range of the list/table you filter -- Regards, Peo Sjoblom "kanstrup" wrote in message ... I have but unfortunately it still counts the rows that I filtered out. Any other ideas? "Don Guillett" wrote: Look in the help index for SUBTOTAL -- Don Guillett Microsoft MVP Excel SalesAid Software "kanstrup" wrote in message ... 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 me at or . 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filters | Excel Worksheet Functions | |||
| How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
| Filters | Excel Discussion (Misc queries) | |||
| Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
| Using Filters | Excel Discussion (Misc queries) | |||
Linear Mode
