Arrays
 

Hi,

I'm built an array that works fine in 2007, but i get the error #NUM! in
excel 2003. Can anyone help me determine the problem.

Here is my array:

{=SUM(IF('[p4 2009 Plan Initiatives web template Tracking - hlyw.xls]Rent
Changes'!$B:$B=A5,IF('[p4 2009 Plan Initiatives web template Tracking -
hlyw.xls]Rent Changes'!$A:$A=$G$3,IF('[p4 2009 Plan Initiatives web template
Tracking - hlyw.xls]Rent Changes'!$G:$G=$G$2,'[p4 2009 Plan Initiatives web
template Tracking - hlyw.xls]Rent Changes'!$F:$F))))+'Original Rent'!G5}

I know the issue is located in the first if stmt.

Thank you!

Arrays
 

xl2007 was the first version that supported entire columns in array formulas.

Maybe you can change the ranges to something that will be sufficient for the
worst case.

David wrote:

Hi,

I'm built an array that works fine in 2007, but i get the error #NUM! in
excel 2003. Can anyone help me determine the problem.

Here is my array:

{=SUM(IF('[p4 2009 Plan Initiatives web template Tracking - hlyw.xls]Rent
Changes'!$B:$B=A5,IF('[p4 2009 Plan Initiatives web template Tracking -
hlyw.xls]Rent Changes'!$A:$A=$G$3,IF('[p4 2009 Plan Initiatives web template
Tracking - hlyw.xls]Rent Changes'!$G:$G=$G$2,'[p4 2009 Plan Initiatives web
template Tracking - hlyw.xls]Rent Changes'!$F:$F))))+'Original Rent'!G5}

I know the issue is located in the first if stmt.

Thank you!

--

Dave Peterson

Arrays
 

It worked! Thank you!



"Dave Peterson" wrote:

xl2007 was the first version that supported entire columns in array formulas.

Maybe you can change the ranges to something that will be sufficient for the
worst case.

David wrote:

Hi,

I'm built an array that works fine in 2007, but i get the error #NUM! in
excel 2003. Can anyone help me determine the problem.

Here is my array:

{=SUM(IF('[p4 2009 Plan Initiatives web template Tracking - hlyw.xls]Rent
Changes'!$B:$B=A5,IF('[p4 2009 Plan Initiatives web template Tracking -
hlyw.xls]Rent Changes'!$A:$A=$G$3,IF('[p4 2009 Plan Initiatives web template
Tracking - hlyw.xls]Rent Changes'!$G:$G=$G$2,'[p4 2009 Plan Initiatives web
template Tracking - hlyw.xls]Rent Changes'!$F:$F))))+'Original Rent'!G5}

I know the issue is located in the first if stmt.

Thank you!

--

Dave Peterson