I have one cell that needs to contain the possible sum of cell
(A1*B1) or (C1*D1) or (E1*F1) but only one of the 3 possibles
For example :
A1 is $10.00 B1 is QTY 1 Sum is $10.00
C1 is $8.00 D1 is QTY 1 Sum is $8.00
E1 is $7.00 F1 is QTY 1 Sum is $7.00

Also would be nice if I could allow only 2 of the cells to contain numbers
at a time
(A1 and B1) or (C1 And D1) ETC and not allow more than one set to give the
sum