Thread: Averageif Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default Averageif Error

I am using the formula

averageif($G219:$N219,"<0") in my workbook however if one of the cells
contains "0" it returns the error #DIV/0!

Why and how can I get rid of it

Thanks