if there is an error

You might have to address the errors. Can't you trap them?

--
Jim
"rmeister" wrote in
message ...
|
| 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
|