Thread: why does a sumproduct formula return a #div/0!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
goonie goonie is offline
external usenet poster
  
Posts: 8
Default why does a sumproduct formula return a #div/0!
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