--Copy the IF() formula down..

--Select the range and set the data validation...Slight change in the formula
=COUNT($A1:$F1)<3

If this post helps click Yes
---------------
Jacob Skaria


"Cbdavis" wrote:

That worked Great !
What if I want to continue that formula in the next rows below that
throughout the sheet?



"Jacob Skaria" wrote:

--You can try the below formula. (all in one line)

=IF(COUNT(A1:B1)=2,A1*B1,IF(COUNT(C1:D1)=2,C1*D1,
IF(COUNT(E1:F1)=2,E1*F1,0)))

--Also to make sure you have only two numbers entered you can set data
validation for this range.. Select A1:F1 . From menu DataValidationselect
'Custom' and copy paste the below formula.

=COUNT($A$1:$F$1)<3

If this post helps click Yes
---------------
Jacob Skaria


"Cbdavis" wrote:

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