LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mar10
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I count items in a filtered list? Counting filtered data. Excel Worksheet Functions 44 April 4th 23 10:22 AM
counting number of particular items in a list vikkam Excel Discussion (Misc queries) 8 July 5th 05 08:35 AM
Counting within a filtered range Jeff Excel Worksheet Functions 2 June 13th 05 03:33 AM
counting similar items in a column bj Excel Discussion (Misc queries) 5 June 6th 05 10:30 PM
Counting Unique Cells When Spread Sheet is Filtered carl Excel Worksheet Functions 1 June 3rd 05 07:20 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"