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