Averaging random cells based on criteria

Hi, I have a large spreadsheet that I want to collect averages from based on meeting certain criteria and returning a blank cell if criteria not met. I thought I should be using the averageifs function but can't seem to get it to work. In attached example I want to show the average figure in columns "e2, j2, o2, t2, y2, ad2 and ai2 if cell a$2:a$6 = a14 " returning a blank if no match. Any suggestions please.

You can use this formula in B14:

=IFERROR(SUMPRODUCT(($A$1:$AI$1="TotalYield")*($A$2:$A$6=$A14),$A$2:$AI$6)/SUMPRODUCT(($A$1:$AI$1="TotalYield")*($A$2:$A$6=$A14)),"")

Use a Custom Format of 0.0;-0.0;; to hide zeros.

Hope this helps.

Pete