View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default VLookup Function ?

Give this formula a try...

=SUMPRODUCT((A1:A9=1)*B1:B9)

Note that I assumed the "1" you are searching on is a number, not text. If
it is in fact text, then use "1" instead of 1.

Rick

I feel like an idiot but I couldn't do something that should be easy. I
have columns in a spreadsheet like the ones below. I want to find all of
the
items with a "1" in the left hand column and total the corresponding
values
in the right hand column. I've been trying to figure this out with one of
the lookup features and I'm lost. Can somebody help? Thanks a ton.

1 16
1 10
5 48
1 15
3 41
1 26
3 42
3 34
1 22