Trimmean If

[sullyman4]

How would one do a Trimmean If statement?

I know Average if and Median if and sum if. but where does the percent go in the statement?

{=trimmean(if(a1:a1000=b2,if(g2:g1000<>"",g2:g1000)))}

my data can really be screwy so a couple of outlier numbers can change the results. significnalty. So a trimmean If statement makes sense. I get an average but can exclude the top and bottom 10%

 

[Aladin Akyurek]

Make sure that the ranges to process are equally sized...

{=TRIMMEAN(IF(A1:A1000=B2,IF(ISNUMBER(G1:G1000),G1:G1000)),0.1)}