| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
error sumproduct #value!
thank you so much.........
"Dave Peterson" wrote: If you have text (even empty strings like "") in those cells, you'll see the error. You could try this syntax that will ignore the text values: =SUMPRODUCT(--(CashBook!$J$24:$J$15098=PL!$C6),--(CashBook!$P$24:$P$15098)) Adjust the ranges to match--but you can't use whole columns (except in xl2007). =sumproduct() likes to work with numbers. The -- stuff changes trues and falses to 1's and 0's. Bob Phillips explains =sumproduct() in much more detail he http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html Tufail wrote: hello all, i am using following sumproduct formula ang facing this error #value ! =SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098)) coulmns "P" contaning formula as under: Col_N Col_O Col_P 9,00 114.14 1,090,000. thanks in advance -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT Error | Excel Discussion (Misc queries) | |||
| error in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| SUMPRODUCT #VALUE! Error | Excel Worksheet Functions | |||
| #ref error with Sumproduct | Excel Worksheet Functions | |||
| SUMPRODUCT ERROR | Excel Discussion (Misc queries) | |||
Threaded Mode
