View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EasyPeasy EasyPeasy is offline
external usenet poster
Posts: 1
Default Calculating Average Length of Service

I've got a spreadsheet that includes 3 columns with range names of 'gender'
(containing either M or F), 'age' and 'company_service' (both expressed as

I want to be able to calculate the average length of service for men and
women separately based on age bands (eg between 21 and 30).

Can someone please start me off with a formula that can handle one set of
conditions from which I can hopefully work out the rest. eg :

Lower Age Band 21
Upper Age Band 30
Gender M