Thread: why does a sumproduct formula return a #div/0!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default why does a sumproduct formula return a #div/0!
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)

Reply With QuoteReply With Quote