| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting a filtered range
Sorry, should have been
=SUBTOTAL(2,A1:A100) 9 is the Sum not Count -- 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting a filtered range
Great, thank you.
"Bob Phillips" wrote: Sorry, should have been =SUBTOTAL(2,A1:A100) 9 is the Sum not Count -- 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting a filtered range
You might need to make it:
=SUBTOTAL(3,A1:A100) 3 being equivalent to COUNTA (for the word "Female"). Hope this helps. Pete On Jul 11, 12:56 am, "Bob Phillips" wrote: Sorry, should have been =SUBTOTAL(2,A1:A100) 9 is the Sum not Count -- 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?- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help Please-Counting Filtered Rows | Excel Worksheet Functions | |||
| Counting a Filtered List | Excel Discussion (Misc queries) | |||
| Counting a Filtered Dataset | Excel Worksheet Functions | |||
| counting filtered items | Excel Worksheet Functions | |||
| Counting within a filtered range | Excel Worksheet Functions | |||
Linear Mode
