Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help Please-Counting Filtered Rows
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help Please-Counting Filtered Rows
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: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REALLY miussing rows in Excel2000 | Excel Discussion (Misc queries) | |||
Counting Unique Cells When Spread Sheet is Filtered | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Counting rows with 3 columns | Excel Worksheet Functions | |||
How can I make autofilter show the filtered number of rows | Excel Worksheet Functions |