software

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: www.excelforum.com/member.php...oamp;userid=30163
View this thread: www.excelforum.com/showthread...hreadid=528607gt;gt;if there is an error

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

--
Jim
quot;rmeisterquot; gt; 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:
www.excelforum.com/member.php...oamp;userid=30163
| View this thread: www.excelforum.com/showthread...hreadid=528607
|
See Tom Ogilvy's reply to a similar question
groups.google.com/group/micro...ba9e0295b0b1e9

Google Groups search:
array average DIV/0 group:*excel*

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

would be recoded as
=IF(ISRRROR(AVERAGE(IF(Sheet1!$F$2:$F$65536=Sheet2 !$A2,Sheet1!$AE$2:$AE$5128))
),quot;quot;,AVERAGE(IF(Sheet1!$F$2:$F$65536=Sheet2!$A2,Sh eet1!$AE$2:$AE$5128)) )

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;rmeisterquot; gt; wrote in message
...
gt;
gt; I am using an array formula that looks like this:
gt;
gt; =AVERAGE(IF(Sheet1!$F$2:$F$65536=Sheet2!$A2,Sheet1 !$AE$2:$AE$5128))
gt;
gt; The formula is working great. The problem is that if there is an error
gt; then I get the #DIV/0!.
gt;
gt; Is there a way I can embed something in this formula that would return
gt; 0 if error.