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