software

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

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

quot;bazquot; gt; wrote in message
...
gt; Please post response as email is bogus to prevent spam.
gt;
gt; I am using Excel 2003. I admit I lost my note on this and appreciate
gt; how to do this.
gt;
gt; I am filtering data. The original list is say 500 rows. When I filter
gt; on measure I see only what I want, but I want to insert a formula that
gt; tells me ONLY how many rows are showing up on that filtering.
gt;
gt; Thanks in advance for any help.
gt;
gt; baz
I think my feeble brain recalled how to do it - Subtotal, condition 3

Thanks for any other thoughts.

baz

On Fri, 16 Dec 2005 17:48:02 GMT, (baz) wrote:

gt;Please post response as email is bogus to prevent spam.
gt;
gt;I am using Excel 2003. I admit I lost my note on this and appreciate
gt;how to do this.
gt;
gt;I am filtering data. The original list is say 500 rows. When I filter
gt;on measure I see only what I want, but I want to insert a formula that
gt;tells me ONLY how many rows are showing up on that filtering.
gt;
gt;Thanks in advance for any help.
gt;
gt;baz