Hi

I am trying to devise a formula that allows me to calculate TRIMMEAN into a summary table provided the year of sale and product code definitions are met.

In the sheet 'Data', the year of sale is contained in column G, the product code is contained in column A, and the data to be trimmed is in column I.

In the summary table, column A contains the year reference and row 1 contains the product code.

Below is my failed attempt.

=TRIMMEAN(IF(AND(data!$G$2:$G$708=$A2,data!$A$2:$A$708=B$1),data!$I$2:$I$708),0.2)

Any ideas of how to do this gratefully received!