Filters

K

kanstrup

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
[email protected] or [email protected]. 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
 
K

kanstrup

I have but unfortunately it still counts the rows that I filtered out. Any
other ideas?
 
P

Peo Sjoblom

That is not possible, use

=SUBTOTAL(3,A2:A1000)

where A2:A1000 is the whole range of the list/table you filter
 
K

kanstrup

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 [email protected]
that would be great too.

Thanks,
Chris
 
P

Peo Sjoblom

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
 
Top