Need help with Average IF formula based on multiple criteria

[maryren]

Hi,
I need to average a column based on two criteria and can't seem to figure this out. I can average based off on one column, but is there a way to average based off of info in two columns?

Sample Spreadsheet:

Location, Number, Average Column
A, 123, 1
A, 123, 2
A, 123, 3
B, 123, 4
B, 123, 5
B, 123, 9

I need to find the average of Location A, Number 123 (i.e., 2) and average of Location B, Number 123 (i.e, 9).

Any suggestions?