Using Index, Match and AVERAGE to compile data

[dsami0122]

Staff Roster (First Tab)

Title (Column A)	Name( Column B)	Rate (Column C)
Admin	Jones	55.00
Manager	Smith	80.00
Manager	John	86.50
Data Clerk	Morre	63.00
Admin	Kim	38.50
Data Clerk	Brand	72.36

AVERAGE (second Tab)

Title (Column A)	Average Rate (Column B)
Admin
Data Clerk
Manager

How to do in INDEX MATCH on the TITLE and Return the Average of the rates based on the Title

I tried this

=AVERAGE(INDEX('Staff Roster '!C:C,MATCH('Average'!A8,'Staff Roster '!A:A,0)))

Only returned the first item it found didnt SUM/AVERAGE ALL

Hope this makes sense

 

[Fluff]

How about

=AVERAGEIFS('Staff Roster '!C:C,'Staff Roster '!A:A,A8)

 

[dsami0122]

PERFECT THANK YOU

 

[Fluff]

You're welcome & thanks for the feedback.