Find average of total column if 3 columns match

[hambly]

I'm looking to find the average total of column D if A, B, C columns match criteria.

I would have the criteria in one sheet and it would be looking at a:a, b:b, c:c, d:d of another sheet.

For example if a="bob" and b=jones" and c="bill" then what is the average of d for all instances.Excelforum_match3_average.xlsx

Small example is attached.

Thanks for your help!

Rob

[jewelsharma]

see AverageIfs formula.

[azumi]

Something like this? Using array formulas

[FDibbins]

Based on your sample data, try this...
=IFERROR(AVERAGEIFS($D$1:$D$15,$A$1:$A$15,"Bob",$B$1:$B$15,"Smith",$C$1:$C$15,"Tony"),"No Match")

Note that you dont have any matches onthe sample you gave, and also, you have a trailing space after Smith

[hambly]

Thanks all... Azumi and Ford both did the job, I ended up going with Ford's method (referencing a cell rather than the name) as it was a lot of data, and the array slowed everything way down...

Thanks again!


Rob

[FDibbins]

Glad we could help, and thanks for the feedback