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
|