View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken D.
 
Posts: n/a
Default Division by Zero Error

I am using this formula to average the values in cells F49:J49 if the value
is greater than zero.

=SUMIF(F49:J49,"0")/COUNTIF(F49:J49,"0")

When all values are 0, I'm getting the division by zero error.

Just a little help please...