# A lookup average

#### erniepoe

##### Active Member
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]])

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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

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

Hey Ernie,

You are welcome!

It works very similar to SUMIF (and SUMIFS).

Hope it works well for you!

Alex

Replies
0
Views
171
Replies
5
Views
242
Replies
1
Views
408
Replies
1
Views
170
Replies
8
Views
290

1,221,059
Messages
6,157,681
Members
451,433
Latest member
AndyB86

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back