View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Inter
 
Posts: n/a
Default multiple lookup_value

I'm not sure SUMPRODUCT is the right formul as i'm not trying to multiply
anything.

The data looks like this;

Source Downloads
10155 200
10156 300
10157 400
10158 500
10159 600

and i'm trying to write a formula that will give me the sum of the downloads
for 10155, 10156 and 10158 (1000)

I've tried both VLOOKUP and SUMIF with arrays
(=VLOOKUP({10156,10155,10158},A1:A5,2,FALSE) and
=SUMIF(A1:A5,{10156,10155,10158},B1:B5) respectively) but neither of these
give me the answer i'm looking for.

Cheers
Stuart