You may have a zero somewhere in your array. Also, check those parentheses.
Maybe:
=SUMPRODUCT((outlook!CV2:CV1931="XNOROPC")*(outloo k!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:CD193 1)