ExcelBanter - How do I hide a divide by zero error from an average formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I hide a divide by zero error from an average formula? (https://www.excelbanter.com/excel-worksheet-functions/126934-how-do-i-hide-divide-zero-error-average-formula.html)

Julia

How do I hide a divide by zero error from an average formula?

Dave Peterson

How do I hide a divide by zero error from an average formula?

=if(count(a1:a10)=0,"No numbers",average(a1:a10))

is one way.

Julia wrote:

--

Dave Peterson

daddylonglegs

How do I hide a divide by zero error from an average formula?

To return a zero rather than #DIV/0!

=SUM(A1:A10)/MAX(1,COUNT(A1:A10))

"Dave Peterson" wrote:

=if(count(a1:a10)=0,"No numbers",average(a1:a10))

is one way.

Julia wrote:

--

Dave Peterson

All times are GMT +1. The time now is 09:57 AM.