Excel compatability 2003-2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vitordf - 25 Sep 2007 12:16 GMT

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,

Reply to this Message

Bob Phillips - 25 Sep 2007 17:36 GMT

Works okay for me. What is the SP formula?

Signature

---
HTH

Bob

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

> Hi, I have created an report in excel 2003 with SUMPRODUCT formula,m
> however
[quoted text clipped - 5 lines]
>
> Thanks,

Reply to this Message

Vitordf - 26 Sep 2007 10:38 GMT

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.

> Works okay for me. What is the SP formula?
>
[quoted text clipped - 7 lines]
> >
> > Thanks,

Reply to this Message

Bob Phillips - 26 Sep 2007 19:21 GMT

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

Signature

---
HTH

Bob

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

> Hi,
>
[quoted text clipped - 18 lines]
>> >
>> > Thanks,

Reply to this Message

Rate this thread: