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
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