Averageing based on other cell values

[drewberts]

Hi

I have a spreadsheet with my staff listed across row 1. Row 2 contains their salaries and row 3 contains their department.

I want to average the salaries of employees based on their department e.g.

Alan Tom Helen
100 150 200
HR HR Admin

I looking for a formula that would return an average of 125 when I set the criteria (which can be fixed) as "HR"

Hope that makes sense

 

[arthurbr]

Try =AVERAGIF(C1:C3,"HR",B1:B3)
(if you have a post 2003 version)

 

[drewberts]

Thanks arthurbr

Knew it would be something simple - didn't work at first but noticed the typo in your formula, so all sorted. Thanks for the quick response

 

[arthurbr]

Yep, good work. The E got stuck in my keyboard
Corrected version for other members =AVERAGEIF(C1:C3,"HR",B1:B3)