I have a similiar problem whereas the last part of my formula is not
averaging but summing my formula: I have
{=average)if(iserr(j10:l10<0),0,average(j10:l10)) )}

what was working was the {=average(if(j10:l10<0,j10:l10,""))} but what i
get in cells with 0 is the #div/ error.

"MrShorty" wrote:


See if this helps. Drop the quotes from around the 0's (...,0,...).
With the quotes in place, the IF function returns the TEXT "0" which
AVERAGE ignores because it's text. Without the quotes, the IF function
will return the number 0 which AVERAGE will acknowledge and include in
your average.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=468863