dimanche 16 juin 2019

Using TRIMMEAN function with multiple conditions

I am having trouble putting together a formula that returns the TRIMMEAN value that fits multiple conditions.

The 'Output' table (screenshot attached) needs to read the data in the 'Dataset' table (screenshot attached), and give back e.g. the trimmean (av excl outliers) of the Quantity of P1020 where Size = S... and so and so forth for all the cells/conditions in the Output table.

I have so far tried =TRIMMEAN(IF(($B$2:$B$14=F2)*($A$2:$A$14=G1),C2:C14),10%) But its returning the average of the entire array instead of looking at only the rows where the Product Size is S and Product code is P1020.

Dataset

Output

Aucun commentaire:

Enregistrer un commentaire