Supressing the #DIV/0! message in this formula?

Al · Sep 18, 2004

=IF(ISBLANK(B276:B306),"",AVERAGE(B276:B306))

Any help appreciated. I would think the above would work, but it doesn't.

Al

Travis Benedict · Sep 18, 2004

I usually use =if(ISERROR(Formula),0,formula)

duane · Sep 18, 2004

=IF(sum(B276:B306)=0,"",AVERAGE(B276:B306)

Sandy Mann · Sep 18, 2004

I assume you mean you get the error when there is no data in B276:B306.
Try:

=IF(ISERROR(AVERAGE(B276:B306)),0,AVERAGE(B276:B306))

HTH

Sandy

Al · Sep 19, 2004

duane said:
=IF(sum(B276:B306)=0,"",AVERAGE(B276:B306))

Works like a charm...I tried some variation of this ( or so I
thought), but it did not work....

This does..

Thanks...