Summing VLookup

[AboveBeyond]

Hi,

I"m trying to get vlookup to find find all lookup values, sum up all of the corresponding values, and return that sum.

So example:

1. $5
1. $6
1. $9

It would return $20.

Thanks for the help!

 

[Aladin Akyurek]

=SUMIF($A$2:$A4,1,$B$2:$B$4)

 

[HalfAce]

Hello AboveBeyond, welcome to the board.
What Aladin posted is right close to what I had in mind, but with a little twist.
Say your numbers were in column A and your prices were in column B.
In some cell somewhere you can enter the formula: =SUMIF(A:A,C1,B:B)
Then just enter the (column A) number of interest in C1 and your formula should return
the sum of all column B values that have your C1 entry in column A.



Hi Aladin.
The fishing is just starting to get good!
You guys need any more?

 

[AboveBeyond]

Thanks for the help, I appreciate it!

I had to do some trial and error to see how the function worked but I got the results I was looking for.


Thanks again!

 

[Aladin Akyurek]

....

Hi Aladin.
The fishing is just starting to get good!
You guys need any more?

The school starts very soon... If you caught too much, you know the address.