| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
error in SUMPRODUCT
hi
i am trying to apply this below formula, but doesn't work well. =SUMPRODUCT(('Sold List'!$L$7:$L$3000=D5)*('Sold List'!$K$7:$K$3000)) this error is coming out - #VALUE! i want bring from Sold List value into Account List and D5 is in Account List hope could be understand. thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT #VALUE! error | Excel Worksheet Functions | |||
| Sumproduct value error | Excel Worksheet Functions | |||
| Sumproduct error | Excel Worksheet Functions | |||
| SUMPRODUCT ERROR | Excel Discussion (Misc queries) | |||
| Sumproduct #num error | Excel Worksheet Functions | |||
Threaded Mode
