Using the lookup Function for similar items to add together

[Guest]

Hello People,

I need to find in column A all the items with a 3 in it and add all items in
column B together.
Example:

A B C H I
1 3 House Results for 3 = 7
3 4 Car
3 2 Bike
2 1 Pool
3 1 Skateboard
4 7 Park

What is the best type of lookup and what would the formula look like.

Thank you

 

[Biff]

Hi!

Try this:

=SUMIF(A1:A6,3,B1:B6)

Or, use a cell to hold the criteria:

D1 = 3

=SUMIF(A1:A6,D1,B1:B6)

Biff