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 ***.
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
Bookmarks