Calculate average - ignore ZERO and N/A

lawi227

Board Regular
Joined
Mar 17, 2016
Messages
123
I have this equation that ignores N/A errors:
{=AVERAGE(IF(NOT(ISNA(E4:E10)),E4:E10))}

It is an array formula. I would also like it to ignore ZERO values.

Thanks!
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Which version of Excel are you using?
XL2007+ try

=AVERAGEIFS(E4:E10,E4:E10,"<>0",E4:E10,"<>#N/A")
 

Watch MrExcel Video

Forum statistics

Threads
1,108,756
Messages
5,524,677
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top