Thread: How do I hide a divide by zero error from an average formula?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 287
Default 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

Reply With QuoteReply With Quote