Counting a filtered range
=SUBTOTAL(9,A1:A100)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Jenny" wrote in message
...
I am looking for a formula that counts the total number of cells in a
filtered list. In my table one of the colunms lists gender. I need a
formula
so that when I filter on female, it gives me the total number of females
in
the list. Can anyone help?
|