| 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 |
| 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 | |||
Threaded Mode
