TRIMMEAN 5 percent and also exclude Zeros?

[Biddlecom]

Hello,

What would the formula be if I wanted to find an average but exclude all zeros and exclude the top and bottom 5 percent?

I know how to exclude the top and bottom 5 percent but I cant figure out how to ignore zeros.

 

[Eric W]

Maybe:

=TRIMMEAN(IF(A2:A26<>0,A2:A26),5%)
confirmed with Control+Shift+Enter, where A2:A26 is your range.

 

[Aladin Akyurek]

A bit kosher: control+shift+enter, not just enter...

=TRIMMEAN(IF(ISNUMBER(1/A2:A26),IF(A2:A26>0,A2:A26)),5%)

 

[Biddlecom]

Thank you both for the help.