Averaging every third column based on a criteria in each preceding column

[Peter Davison]

In Row 5 I have a range in columns BC to CJ which have a value in the following cells BF, BI, BL, BO, BR, BU, BX, CA, CD, CG, CJ
In the columns preceding each of the columns (BE, BH, BK, BN, BQ, BT, BW, BZ, CC, CF, CI) I have a number 1 through to 10 (this number can be repeated in any of the columns)
I have the numbers 1 to 10 as a header in Row 4 columns EA to EJ
Under each respective number I want to get the average of the numbers in BF, BI, BL, BO, BR, BU, BX, CA, CD, CG, CJ but only if the number in the preceding columns matches the number in the column I have the formula in.

I've got to this stage with - =SUMPRODUCT(--(MOD(COLUMN(BD5:CJ5)-COLUMN(BD5)+1,3)=0),BD5:CJ5) which gives me a sum but I can't work out how to get the average and based on the criteria above.

I'm hoping I've explained it ok.
As always any help would be most appreciated.
Regards

 

[Fluff]

How about

=AVERAGE(FILTER($BF5:$CJ5,($BE5:$CI5=EA$4)*(MOD(COLUMN(BF5:CJ5),3)=1),0))

 

[Peter Davison]

That is brilliant.
You are so helpful and amazing.
Really appreciate your help.
Its saved me so much time.
Thank you

 

[Fluff]

You're welcome & thanks for the feedback.