Average formula to exclude outliers and zero

[kumara_faith]

Hi,

I have a set of data that I would like to calculate the average excluding outliers (more than 800) and zeros. I am using the formula formula for excluding the outliers:

=AVERAGEIF(C4:C21,"<"&800,C4:C21)

Is there a way to modify to exclude zeros as well ?

Appreciate all the help.

 

[offthelip]

try this:
=AVERAGEIFS(C4:C21,C4:C21,"<800",C4:C21,">0")

Note AVERAGEIFS