Thread
:
CountA with filtered column
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett