Filters

[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
(e-mail address removed) or (e-mail address removed). 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

 

[Don Guillett]

Look in the help index for SUBTOTAL

 

[kanstrup]

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

 

[Peo Sjoblom]

That is not possible, use

=SUBTOTAL(3,A2:A1000)

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

 

[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 (e-mail address removed)
that would be great too.

Thanks,
Chris

 

[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