Hi,

I am attempting to summarize some stats for our Loss Prevention Department.
1 group of positions is trending high (position A, for example), so I want to
further breakdown the stats for this subgroup. I am having trouble finding a
function which will allow me to do this. Can anybody help me with writing the
basic formula or function that will allow me to pull info for this subgroup?

I need to pull out stats such as
% female in position A are ?
Avg $ admission position A
% <90 days employment positon A
ETC, ETC, ETC.

Each month I will have to pull new records from my access DB and put them
into the spreadsheet for updated analysis.

Any help will be greatly appreciated!