Correct Formula to Use to Populate Averages

[simplyrose]

Hi,

I can't work out what formula to use to resolve the issue below:

Populate the table to show the average base salary by country and job band in GBP. If there are no employees show a blank cell rather than a zero:

Ive attached the work book.

I thought it would be a VLOOKUP but how do you in bed an average function into that?

Any help or guidance appreciated

[Pete_UK]

You can use this formula in B7 of Sheet1:

=IFERROR(AVERAGEIFS(Sheet2!$K:$K,Sheet2!$G:$G,B$6,Sheet2!$C:$C,$A7),"")

then copy across and down as required.

Hope this helps.

Pete

P.S. This sounds like a homework question to me

[crazyforexcel]

I am late on this one but it is using the same formula that Pete provided.

[Richard Buttrey]

I agree with Pete's offering.

I initially picked up column K and then saw the 'Annual Base Salary' which is column E and used that.
Now after looking again I'm assuming column K is indeed the base salary although the column label doesn't suggest it since all the column K values are the same % of column E

I did wonder if this was a homework question. If not then a Pivot table would be the other way to present the results.