Hi,
is it possible that some of your data is text looking like a number?


HOW TO GET FURTHER HELP WITH A WORKBOOK
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join you will have the
opportunity to add attachmnets to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so. :)


Michelle;333469 Wrote:
Bump....

"Michelle" wrote:

Hi, I'm having a problem with a sumproduct formula thats not
returning data
consistently.

I have a datasheet that has all the formulas in that is working fine.
I then
have a summary sheet for the managers which allows them to choose
what they
want to look at and the sheet populates using sumproduct formulas
that
reference off the datasheet. The summary sheet looks like this:

Product (which is a drop down)

Region Measure Q1 Q2 Q3 Q4 etc
WCE Conversion rate 0% 0% 0% 0%
WCE Indirect 37% 40% 39% 15%

etc
The sumproduct formula is:
=(SUMPRODUCT((DSReg=$A5)*(DSProd=$B$2)*(DSKPI=$B5) ,DSQ109Amt))
DSREG is the region, DSProd is the product in the drop down, DSKPI is
the
Measure eh Conversion rate.
I've double checked all the range's agree and the names are right,
and the
reference cells tie up. Has anyone any idea why the formula is
working
correctly for Indirect but not for Conversion rate?

I've done some experimenting and I'm fairly sure that its the range
DSKPI
thats causing the problem- Ive tried deleting it and redoing the
range but
that didn't fix it.


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=92203