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.

1	2	3	4	Result	Average of Result
A	1000	B	G	50	100
B	1200	B	P	45	45
C	1600	C	A	74	74
A	1000	B	G	150	100
A	1200	B	B	30	30

<tbody>
</tbody>

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.