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

Filters
 

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

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

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

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

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
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