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 |
Averageif Error
In excel 2007 the below works if atleast there is one entry which is not = 0
=AVERAGEIF($G219:$N219,"<0") If you mean to avoid div error if all the cell values are 0 then try the below =IF(SUM($G219:$N219),AVERAGEIF($G219:$N219,"<0"), "") If this post helps click Yes --------------- Jacob Skaria "Curtis" wrote: 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 |
Averageif Error
Actually, you're getting the error if there are no cells that are non-zero,
right? If the range is always numeric, then you could use: =if(countif($g219:$n219,"<0")=0,"no numbers",your formula here) Or you could check to see if the only numbers were 0's: =IF(COUNT($G219:$N219)=COUNTIF($G219:$N219,0),"no numbers","your formula here") Curtis wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 01:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com