Formula that works in xl2003 but not xl2007

**DrSwaity** · 06-09-2009, 02:08 PM

I have this formula :

=SUM(F25:M25*$F$6:$M$6)

It works great in xl2003, and it works properly in XL2007 until you try and change it. I changed the column F to Column D and now it gives me a #value.

How can I re-work this for xl2007?

THanks

**NBVC** · 06-09-2009, 02:13 PM

That formula would need to be confirmed with CTRL+SHIFT+ENTER to work as it is an Array formula...

Try instead the more appropriate Sumproduct() function:

=SUMPRODUCT(F25:M25,$F$6:$M$6)

or

=SUMPRODUCT(D25:M25,$D$6:$M$6)

Which is confirmed with ENTER only.

**DrSwaity** · 06-09-2009, 02:24 PM

Wow, thank you so much for the incredibly fast and accurate reply!

That was awesome!

**NBVC** · 06-09-2009, 02:29 PM

You are welcome,

Please remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save