Formula Needed

[Hawknismo]

Hi All,

Hope some one can help me. After 3 days of struggling with this i'm absolutely speech less. With virtually zero experience of excel this turned out to be even more confusing than i thought.

My issue: I have 5 columns (Text/Number/Text/Text = Result) of the first 4 columns there is more than 6000 combinations.
what I need is, the average of the result for any of the combinations that comes up. [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]Result[/TD]
[TD]Average of Result[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1000[/TD]
[TD]B[/TD]
[TD]G[/TD]
[TD]50[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1200[/TD]
[TD]B[/TD]
[TD]P[/TD]
[TD]45[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1600[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]74[/TD]
[TD]74[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1000[/TD]
[TD]B[/TD]
[TD]G[/TD]
[TD]150[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1200[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]30[/TD]
[TD]30[/TD]
[/TR]
</tbody>[/TABLE]

Any help would be much appreciated

 

[Special-K99]

=AVERAGEIFS(E$2:E$6,A$2:A$6,A2,C$2:C$6,C2,D$2:D$6,D2)
and copy down the column

Basically give an average of column E where column A matches A2, column C matches C2 and column D matches D2

 

[Hawknismo]

Thank you Special-K99 it's exactly what i needed.