Prev: Synchronous scrolling in all sheets of a wokbook.
Next: Working from oldest date
From: goonie on 9 Sep 2009 09:06
The sumproduct formula that I'm using is returning #div/0!.

Here's the formula: =SUMPRODUCT((outlook!CV2:CV1931="XNOR
OPC")*(outlook!CU2:CU1931="jpy")*outlook!CD2:CD1931)

From: Max on 9 Sep 2009 09:15
One possibility: the range: outlook!CD2:CD1931 contains #DIV/0!
Check & clean it up, and it'll work fine
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"goonie" wrote:
> The sumproduct formula that I'm using is returning #div/0!.
>
> Here's the formula: =SUMPRODUCT((outlook!CV2:CV1931="XNOR
> OPC")*(outlook!CU2:CU1931="jpy")*outlook!CD2:CD1931)
>
From: Gary''s Student on 9 Sep 2009 09:18
You probably have a divide by zero error somewhere in your referenced data.
--
Gary''s Student - gsnu200902


"goonie" wrote:

> The sumproduct formula that I'm using is returning #div/0!.
>
> Here's the formula: =SUMPRODUCT((outlook!CV2:CV1931="XNOR
> OPC")*(outlook!CU2:CU1931="jpy")*outlook!CD2:CD1931)
>
From: ryguy7272 on 9 Sep 2009 09:21
You may have a zero somewhere in your array. Also, check those parentheses.
Maybe:
=SUMPRODUCT((outlook!CV2:CV1931="XNOROPC")*(outlook!CU2:CU1931="jpy")*(outlook!CD2:CD1931))

or

=SUMPRODUCT(--(outlook!CV2:CV1931="XNOROPC"),--(outlook!CU2:CU1931="jpy"),--(outlook!CD2:CD1931))


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gary''s Student" wrote:

> You probably have a divide by zero error somewhere in your referenced data.
> --
> Gary''s Student - gsnu200902
>
>
> "goonie" wrote:
>
> > The sumproduct formula that I'm using is returning #div/0!.
> >
> > Here's the formula: =SUMPRODUCT((outlook!CV2:CV1931="XNOR
> > OPC")*(outlook!CU2:CU1931="jpy")*outlook!CD2:CD1931)
> >
From: goonie on 9 Sep 2009 09:25
Thank you so much - It was driving me crazy! The formula always worked before
and now it does again!!!!

"Max" wrote:

> One possibility: the range: outlook!CD2:CD1931 contains #DIV/0!
> Check & clean it up, and it'll work fine
> Any good? hit the YES below
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> Downloads:27,000 Files:200 Subscribers:70
> xdemechanik
> ---
> "goonie" wrote:
> > The sumproduct formula that I'm using is returning #div/0!.
> >
> > Here's the formula: =SUMPRODUCT((outlook!CV2:CV1931="XNOR
> > OPC")*(outlook!CU2:CU1931="jpy")*outlook!CD2:CD1931)
> >
 |  Next  |  Last
Pages: 1 2
Prev: Synchronous scrolling in all sheets of a wokbook.
Next: Working from oldest date