Filter and average ignoring zero

[MH Tan]

Hi

I have a set of data and all field with filter. One of them I need to average them and ignoring zero.

I have tried with =IFERROR(AVERAGEIF(range,">0"),0).

It is Ok on igoring zero but not change with filter.

Please teach on what formula I should do?

Thanks

MH

 

[awoohaw]

try:

Book1
	A	B	C	D	E
1
2	10	22		10	22
3	10			10
4				50
5				20
6	50			20
7	20
8	20
Sheet1

Cell Formulas
Range	Formula
B2	B2	=AVERAGEIF(A2:A8,"<>"&0)
E2	E2	=AVERAGE(D2:D6)