Home |
Search |
Today's Posts |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct and Vlookup
All - Thanks for your help, but I have just found the answer on the xldynamic
page. In case you were interested it needs a -- in front of it. ie. =SUMPRODUCT(--('Dump'!CQ3:CQ101=Holdings!AA5)*('Dump'!CL3:CL101) ) Regards. "Nav" wrote: But this still has numbers in it so I would still expect a value to be shown. Would this have to be formatted as number? Any further ideas anyone? "Bryan Hessey" wrote: Perhaps also that 91 from A1:DB151 would appear to be column CM, and the Sumproduct is using CL Ken Wright Wrote: You have AA4 in one formula and AA5 in another???? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Nav" wrote in message ... I have a list of data in a different worksheet, and if I use vlookup ie. =VLOOKUP(AA4,'Dump'!$A$1:$DB$151,91,FALSE) - It brings back a value, however if I use Sumproduct =SUMPRODUCT('Dump'!CQ3:CQ101=Holdings!AA5)*('Dump' !CL3:CL101) It brings back 0, does anyone know why this is? The reason I need to use sumproduct is because some IDs have more that 1 row of data, so I need to sum it. Thanks in advance for any help/ideas. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=490533 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Which SumProduct Sumif or VLookup? | Excel Discussion (Misc queries) | |||
VLOOKUP in SUMPRODUCT array | Excel Worksheet Functions | |||
I've tried Sumproduct, SumIf, Vlookup and Hlookup. | Excel Worksheet Functions | |||
Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions |