Filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
That is not possible, use

=SUBTOTAL(3,A2:A1000)

where A2:A1000 is the whole range of the list/table you filter
 
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
 
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
 
Back
Top