[SOLVED] error message #DIV/0! when using AVERAGE formula for multiple cells

[ingie424]

Getting error message #DIV/0! when using the following formula =AVERAGE(B6:I6).
How do I correct when some cells have a zero?

[daddylonglegs]

You will only get an error when no cells have numbers

You can avoid that with IFERROR to return a blank

=IFERROR(AVERAGE(B6:I6),"")

....but that will still include zeroes in the average, if you want to average without zeroes use AVERAGEIF instead, i.e.

=IFERROR(AVERAGEIF(B6:I6,">0"),"")