Help Please-Counting Filtered Rows
Look in help for SUBTOTAL
=SUBTOTAL(3,range)
will count visible text and number values, equivalent to COUNTA
2 is the equivalent to COUNT
--
Regards,
Peo Sjoblom
"baz" wrote in message
...
Please post response as email is bogus to prevent spam.
I am using Excel 2003. I admit I lost my note on this and appreciate
how to do this.
I am filtering data. The original list is say 500 rows. When I filter
on measure I see only what I want, but I want to insert a formula that
tells me ONLY how many rows are showing up on that filtering.
Thanks in advance for any help.
baz
|