=SUMPRODUCT(--(ISNUMBER(MATCH(A2:A20,{"Code1","Code2","Code3","C ode4","Code5
"},0))),B2:B20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Inter" wrote in message
...
I have a spreadsheet with a list of source codes in column A and the
number
of downloads associated with each source code in column B.

What i'd like to do is add the number of downloads from a range of source
codes together. I've been using the VLOOKUP function but this is getting a
little long.

To put it another way, i want to find the number of downloads for each of
5
different source codes and add them together.

I've tried using SUMIF but can't seem to make it work correctly.

Any assistance would be very gratefully received.
Many thanks

Or even

=SUMPRODUCT(SUMIF(A2:A20,{"Code1","Code2","Code3", "Code4","Code5"},B2:B20))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bob Phillips" wrote in message
...

=SUMPRODUCT(--(ISNUMBER(MATCH(A2:A20,{"Code1","Code2","Code3","C ode4","Code5
"},0))),B2:B20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Inter" wrote in message
...
I have a spreadsheet with a list of source codes in column A and the
number
of downloads associated with each source code in column B.

What i'd like to do is add the number of downloads from a range of
source
codes together. I've been using the VLOOKUP function but this is getting
a
little long.

To put it another way, i want to find the number of downloads for each
of
5
different source codes and add them together.

I've tried using SUMIF but can't seem to make it work correctly.

Any assistance would be very gratefully received.
Many thanks