View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jenny jenny is offline
external usenet poster
 
Posts: 52
Default Counting a filtered range

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?