Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CountA with filtered column
How do I count the values in the rows showing in a column after applying a
filter to the worksheet? When I do something like =counta(b2:b450) I get 449 but this is not correct after using the filter. Thanks, -- Lee Coleman |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CountA with filtered column
Have a look in the help index for SUBTOTAL
-- Don Guillett SalesAid Software "Lee Coleman" wrote in message ... How do I count the values in the rows showing in a column after applying a filter to the worksheet? When I do something like =counta(b2:b450) I get 449 but this is not correct after using the filter. Thanks, -- Lee Coleman |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CountA with filtered column
Lee
Try this: =SUBTOTAL(3,B2:B450) George Gee "Lee Coleman" wrote in message ... How do I count the values in the rows showing in a column after applying a filter to the worksheet? When I do something like =counta(b2:b450) I get 449 but this is not correct after using the filter. Thanks, -- Lee Coleman |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CountA with filtered column
Thanks it worked great.
Lee "George Gee" wrote in message ... Lee Try this: =SUBTOTAL(3,B2:B450) George Gee "Lee Coleman" wrote in message ... How do I count the values in the rows showing in a column after applying a filter to the worksheet? When I do something like =counta(b2:b450) I get 449 but this is not correct after using the filter. Thanks, -- Lee Coleman |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CountA with filtered column
Note that this works only with filtered rows, and not if you hide any of
them manually. If you do want to hide any manually then this can be catered for as well by adding 100 to the argument, so where you might use the argument 3 as per the example given to you, then 103 will allow you to exclude manually hidden rows as part of your filtered data. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Lee Coleman" wrote in message ... Thanks it worked great. Lee "George Gee" wrote in message ... Lee Try this: =SUBTOTAL(3,B2:B450) George Gee "Lee Coleman" wrote in message ... How do I count the values in the rows showing in a column after applying a filter to the worksheet? When I do something like =counta(b2:b450) I get 449 but this is not correct after using the filter. Thanks, -- Lee Coleman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Macro Help | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |