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
|