Providing an average bsed on a number of criteria

[sallysunshine]

Hi

How do I avoid the #DIV/0! error message if a divisor cell has no value in it? Could someone please tell me how to alter the following formula to do this:

=AVERAGEIFS(N5:N20,P5:P20,"Industrial")

Thanks a lot

 

[cyrilbrd]

Hi

How do I avoid the #DIV/0! error message if a divisor cell has no value in it? Could someone please tell me how to alter the following formula to do this:

=AVERAGEIFS(N5:N20,P5:P20,"Industrial")

Thanks a lot

=IFERROR(AVERAGEIFS(N5:N20,P5:P20,"Industrial"),"")
or =IFERROR(AVERAGEIF(P5:P20,"industrial",N5:N20),"") since you have only ONE criteria...