Formula Needed

[baggarwal]

Hi All: I need a formula that will calculate the average based on multiple conditions.

Here is the sample data:
DLP English 10
DLP French 20
DLP English 10
STP French 10

I am looking for a formula that will look for a match of DLP (Column A) and English (Column B) and then will average the matches (i.e. (10+10)/2 =10)

Can someone please tell me how to do this.

 

[mikerickson]

Try
=SUMPRODUCT(--(A1:A10="DLP"),--(B1:B10="English"),C1:C10) / SUMPRODUCT(--(A1:A10="DLP"),--(B1:B10="English"))

 

[Greg Truby]

You fail to tell us which version of Excel you are using. Mike's formula will work for all versions of Excel. If you're using Excel 2007 or better, you might find the averageifs() function a little more intuitive.

• =AVERAGEIFS(C1:C4,A1:A4,"DLP",B1:B4,"English")