Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting filtered items
I have spreadsheet with about 20 data fields (columns). But for
simplicity I've created my question just using a few fields - but the answer will really apply to the additional fields I have on my spreadsheet. I have a spreadsheet the contains the year a new employee was hired, their name and their sex. A number of different people will be viewing this and I would like to allow them to filter what items they'd like to see and then creat a count on the M (males) and F (females) found on the filtered items. I was thinking @countif would work, but it does not apply just to the filtered data. Is there another function I'm not aware of? Thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I count items in a filtered list? | Excel Worksheet Functions | |||
counting number of particular items in a list | Excel Discussion (Misc queries) | |||
Counting within a filtered range | Excel Worksheet Functions | |||
counting similar items in a column | Excel Discussion (Misc queries) | |||
Counting Unique Cells When Spread Sheet is Filtered | Excel Worksheet Functions |