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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |