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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if it match the column criteria
Hello,
Just to add few comments. sometime this codes changes columns and some time one or two code may not appear. So looking for consistent formula where it works in different scenarios. Thanks. Dinesh "Dinesh" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if it match the column criteria
Try these:
For col G: =SUM(SUMIF(A1:F1,{1,9},A2:F2)) For col H: =SUM(SUMIF(A1:F1,{5,8},A2:F2)) For col I: =SUM(SUMIF(A1:F1,{7,4},A2:F2)) Biff "Dinesh" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if it match the column criteria
Thanks Biff. Perfect.
"T. Valko" wrote: Try these: For col G: =SUM(SUMIF(A1:F1,{1,9},A2:F2)) For col H: =SUM(SUMIF(A1:F1,{5,8},A2:F2)) For col I: =SUM(SUMIF(A1:F1,{7,4},A2:F2)) Biff "Dinesh" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if it match the column criteria
You're welcome. Thanks for the feedback!
Biff "Dinesh" wrote in message ... Thanks Biff. Perfect. "T. Valko" wrote: Try these: For col G: =SUM(SUMIF(A1:F1,{1,9},A2:F2)) For col H: =SUM(SUMIF(A1:F1,{5,8},A2:F2)) For col I: =SUM(SUMIF(A1:F1,{7,4},A2:F2)) Biff "Dinesh" wrote in message ... 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 |
Reply |
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) |