Excel compatability 2003-2007

[Guest]

Hi, I have created an report in excel 2003 with SUMPRODUCT formula,m however
when openned in 2007 the calles display #value, can you please let me know if
the 2007 version is not compatible with this formula or is a settings issue.
I have checked the add ins Analysis Tool Pack and Analysis Tool Pack-VBA.

Thanks,

 

[Bob Phillips]

Works okay for me. What is the SP formula?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Hi,

The SP formula is;
=IF($B$7="","",SUMPRODUCT(--(Data!$G$2:$G$25000=$B$7),--(Data!$H$2:$H$25000=$D13),--(Data!$B$2:$B$25000=$E$8)))

If helps let me know where can I send you the excel file.

Thanks for the help.

 

[Bob Phillips]

Yeah, send it on over, as the formula looks innocuous.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)