Summing values in a LOOKUP formula

[danfarr1]

I'm new to excel formulas and need alittle help. I've created a lookup function for a range of cells. I want the formula to add/sum all of the cells that fall within the lookup. Any idea how to do this???

Here is my formula...
=LOOKUP(A2,'Purchase Log'!A:A,'Purchase Log'!B:B)

I need my formula to add/sum the 'Purchase Log'!B:B

Thank you for any help.

 

[Jonmo1]

Welcome to the board..

Try the SUMIF function

=SUMIF('Purchase Log'!A:A,A2,'Purchase Log'!B:B)

 

[jbeaucaire]

I think you're looking for a SUMIF formula:

=SUMIF('Purchase Log'!A:A,A2,'Purchase Log'!B:B)

 

[danfarr1]

I totally had the wrong formula. Thank you so much for your help, SUMIF is exactly what I needed. Thanks!