Using the lookup Function for similar items to add together
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
"Brian" wrote in message
...
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
|