Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does a sumproduct formula return a #div/0!
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:CD193 1) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does a sumproduct formula return a #div/0!
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) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does a sumproduct formula return a #div/0!
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:CD193 1) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does a sumproduct formula return a #div/0!
goonie,
Select each of the ranges (outlook!CV2:CV1931, etc), then use Edit / Go To... Special Formulas uncheck all but "errors" and press OK. That will select your cells with errors. Or use data filters on the ranges, and select the error values from the dropdown to show just those cells. HTH, Bernie MS Excel MVP "goonie" wrote in message ... 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) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does a sumproduct formula return a #div/0!
Welcome, glad to hear ..
-- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "goonie" wrote in message ... Thank you so much - It was driving me crazy! The formula always worked before and now it does again!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return text using Sumproduct | Excel Worksheet Functions | |||
Sumproduct to return a text | Excel Worksheet Functions | |||
Sumproduct - formula to return data OTHER than given criteria | Excel Worksheet Functions | |||
Sumproduct if rank <=5 if not return 0 | Excel Discussion (Misc queries) | |||
Sumproduct - Return a String | Excel Discussion (Misc queries) |