An if statement that does the averaging calc only when it is not zero.

"tillyosu" wrote:


How can I make excel ignore a #DIV/0! error when averaging a range of
cells???


--
tillyosu
------------------------------------------------------------------------
tillyosu's Profile: http://www.excelforum.com/member.php...o&userid=25114
View this thread: http://www.excelforum.com/showthread...hreadid=388049