Arrays

[David]

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]

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.

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!

 

[David]

It worked! Thank you!

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.

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!