Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add multiple vlookup results
I have a spreadsheet that contains names of groups and numerical results for
them as below. Column A Column B Frame .50 Build .25 Assy 1 .33 Build 1.5 I need to write a formula that will look for all the occurances of "Build" and add the numerical amounts together. I've been trying to do it with vlookup, but maybe that's not the best choice. Does anyone know the best way to do this? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP not returning results | Excel Worksheet Functions | |||
Calculate multiple results from multiple input values? | Excel Discussion (Misc queries) | |||
LOOKUP multiple results but ignore duplicates. | Excel Worksheet Functions | |||
Multiple vlookup | Excel Discussion (Misc queries) | |||
format cell based on results of vlookup function | Excel Worksheet Functions |