Ron Rosenfeld <(EMail Removed)> wrote in
news:(EMail Removed):
> On Sun, 6 Jul 2008 19:33:04 0700 (PDT), "Ben C." <(EMail Removed)>
> wrote:
>
>>Hello all,
>>
>>I am moving from Excel 2003 to Excel 2007. One problem I'm having is
>>with the following array formula which works in 2003 but returns a
>>#VALUE! in 2007. Is there something I need to change in my 2007 setup
>>to make this work?
>>
>>{=(SUM(IF(LEN($H$7:$H$476)<>0,1,0))1)(SUM(IF(LEN($K$7:$K
>>$476)<>0,1,0))1)}
>>
>>... I know there are probably more efficient ways of doing this so I'm
>>not looking for better solutions. I'm wondering ... why won't it work?
>>There are 3 array formulas on the spreadsheet and all are returning
>>#VALUE!
>>
>>Thanks in advance!
>>
>>Ben Cacace
>
> Did you copy the formula *WITHOUT* the braces {...} and then hold down
> <ctrl><shift> while hitting <enter>, allowing Excel to place the
> braces automatically?
> ron
Ben,
ron is right.
i just copied & pasted your formula,
i had to delete the curly braces, and hit CSE,
and the formula worked just fine in Excel 2007.
