Need help with Average IF formula based on multiple criteria

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?

Hello Maryren,

Based on your profile, you are using Excel 2007, so take a look on AVERAGEIFS.

=AVERAGEIFS(AverageColumn,Location,"A",Number,123)

If you need compatibility with pre 2007 versions, could use this Array Formula with CTRL+SHIFT+ENTER

=AVERAGE(IF(Location="A",IF(Number=123,AverageColumn)))

All ranges must be in equal size. The first range is A1:A6 & others are from 2nd row.

=AVERAGE(IF(A2:A6="A",IF(B2:B6="123",C2:C6)))

Change A1:A6 to A2:A6

Also, for the numbers if you are using REAL numbers remove quotes between the number ("123") just use =123