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
|