Thread: AVERAGE function returns #DIV/0! error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KhaVu
 
Posts: n/a
Default AVERAGE function returns #DIV/0! error
I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
Is there a safe proof way to omit the invalid values out of the average
calculation.
Reply With QuoteReply With Quote