- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Excel 2003 Array Formula in Excel 2007

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

- Re: Excel 2003 Array Formula in Excel 2007 posted by Bob Phillips on Mon, 7 Jul 2008
- Re: Excel 2003 Array Formula in Excel 2007 posted by Ron Rosenfeld on Sun, 06 Jul 2008
- Re: Excel 2003 Array Formula in Excel 2007 posted by JustAsking on Tue, 29 Jul 2008