A lookup average

[erniepoe]

Hi all,

I currently have the below formula that finds the average salary based on the job title in column A of a table. However, I also have a location column in that table, and am wondering if the formula can be tweaked so that it is looking at both Job Title AND Location in order to find the average salary based on both those criteria?

Thanks so much for any help.

Ernie






=SUMIF($D$19:$D$84,[@[Job Title]],$G$19:$G$84)/COUNTIF($D$19:$D$84,[@[Job Title]])

 

[Alex0013]

Hello Ernie,

If you have Excel 2007 or higher, use =AVERAGEIFS() I think this should be what you are looking for.

It will average a range of cells given that multiple conditions are met.

Will this work for you?

Regards,
Alex

 

[erniepoe]

Hi Alex,

YES, i have excel 2010 but am unfamiliar with that formula. I will look it up, thanks.

Hello Ernie,

If you have Excel 2007 or higher, use =AVERAGEIFS() I think this should be what you are looking for.

It will average a range of cells given that multiple conditions are met.

Will this work for you?

Regards,
Alex

 

[Alex0013]

Hey Ernie,

You are welcome!

It works very similar to SUMIF (and SUMIFS).

Hope it works well for you!

Alex