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,

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)



"Vitordf" wrote in message
...
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,

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" wrote:

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)



"Vitordf" wrote in message
...
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,

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)



"Vitordf" wrote in message
...
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" wrote:

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)



"Vitordf" wrote in message
...
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,