| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if it match the column criteria
Hello, col A1 thru F1 has following codes 1,5,7,8,4,9 Col a2 thru F2 has 10,15,25,50,55,60 values col G, H & I need a formula where col G would add the value based on code 1 & 9, Col H would add the value based on code 5 & 8 and col I would add the value based on code 7 & 4. Thanks for the soultion. Dinesh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match 2 criteria with 2 criteria | Excel Worksheet Functions | |||
| Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
| Count rows that match criteria in 2 different column cell ranges | New Users to Excel | |||
| Using Match with multiple criteria | Excel Worksheet Functions | |||
| Match 2 Criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
