Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A error in sumproduct
Try using error check or autofilter to check out you data in D2:D3000, with a
lot of data it can be easy to miss one error. If even one cell is a error it can error out the sumproduct. -- If this helps, please remember to click yes. "Joe M." wrote: Here is my formula: =SUMPRODUCT((Data!$E$2:$E$3000=$A$1)*(Data!$C$2:$C $3000=$A3)*(Data!$D$2:$D$3000="N")) If I remove the last segment *(Data!$D$2:$D$3000="N") then I get a result. When it's included I get #N/A. In Data!D2:D3000 is the result of an =if that results in Y or N. I also tried changing the =if to 1 or 0 with the same result. Can someone help? Thanks! Joe M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
another sumproduct with #value error... | Excel Worksheet Functions | |||
sumproduct value error | Excel Discussion (Misc queries) | |||
SUMPRODUCT with #VALUE error | Excel Worksheet Functions | |||
Sumproduct error | Excel Worksheet Functions | |||
SUMPRODUCT ERROR | Excel Discussion (Misc queries) |