Excel 2003 Array Formula in Excel 2007

Giganews Newsgroups
Subject: Excel 2003 Array Formula in Excel 2007
Posted by:  Ben C (bcaca…@gmail.com)
Date: Sun, 6 Jul 2008

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

Replies