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