Excel compatability 2003-2007
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,
|