Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the lookup Function for similar items to add together
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
lookup function | Excel Worksheet Functions | |||
LOOKUP function | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions |