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

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