Hi I am a novice with excel but need to know if there is a formula I can put in a cell to achieve this.

I need to get an average of the E column when the adjacent A column, B column and C column have cerain values.

I have sort of done it by creating hiden columns and the if statement but as there are 108 different combinations of A B and C I have had to make 108 hidden columns and this isnt ideal.

so for example If A1=x and B1=y and C1=z then E1 would be included in the average and if A2=x and B2=f and C2=z then E2 wouldnt be included in the average etc.

I hope this is clear and I hope you can help.

Cheers Flickflucker