Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two arrays same? | Excel Discussion (Misc queries) | |||
Arrays | Excel Worksheet Functions | |||
Use of arrays | Excel Worksheet Functions | |||
Arrays | Excel Discussion (Misc queries) | |||
Need help with arrays (I think) | Excel Worksheet Functions |