I am using an array formula that looks like this:

=AVERAGE(IF(Sheet1!$F$2:$F$65536=Sheet2!$A2,Sheet1 !$AE$2:$AE$5128))

The formula is working great. The problem is that if there is an error
then I get the #DIV/0!.

Is there a way I can embed something in this formula that would return
0 if error.


--
rmeister
------------------------------------------------------------------------
rmeister's Profile: http://www.excelforum.com/member.php...o&userid=30163
View this thread: http://www.excelforum.com/showthread...hreadid=528607