It works, but I meant

=SUMPRODUCT(SUMIF(A2:A20,{10155,10156,10158},B2:B2 0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bob Phillips" wrote in message
...
Well you may think that, but you are wrong

=SUMPRODUCT(SUMIF(A2:A20,{"10155",10156,10158},B2: B20))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Inter" wrote in message
...
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