Average of a set of Array Values

[ItWillAllWorkOut]

Thanks for your help.

I have Column A which is an Employees birth Year, Column B which is salary, and Column C which is a list of Years.

I need a formula to read the Year in Column C, refer to Column A finding all the rows that match that year, than refer to Column B (salaries) and find the average of the salaries.

I am not sure why I am having tgrouble figuring this one out but thanks again for any help.

 

[JoeMo]

Take a look at the AVERAGEIF function in Excel Help.