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) |
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) |