Preccor
New Member
- Joined
- Jul 11, 2019
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
=IF(OR(I2="x"),"2.5","") generates the value 2.5 in cell Q2
=IF(OR(J2="x"),"2.5","") generates the value 2.5 in cell R2
=IF(OR(K2="x"),"2.5","") generates the value 2.5 in cell S2
=IF(OR(L2="x"),"2.5","") generates the value 2.5 in cell T2
=IF(OR(M2="x"),"2.5","") generates the value 2.5 in cell U2
=IF(OR(N2="x"),"2.5","") generates the value 2.5 in cell V2
=IF(OR(O2="x"),"2.5","") generates the value 2.5 in cell W2
I would like to sum total the values in cells Q2:W2 when "X" is not entered in any of the cells in the range I2:O2.
For example ... there is no "X" in cell O2. This renders an error value in G2. [See Image #3]
(Image #2: Sum total works fine which is illustrated in #1)
Question: What is the formula required in cell G2 to sum total the cells in range Q2:W2 when an "X" is missing in any of the cells in range I2:O2?
Image attached for illustration.
=IF(OR(J2="x"),"2.5","") generates the value 2.5 in cell R2
=IF(OR(K2="x"),"2.5","") generates the value 2.5 in cell S2
=IF(OR(L2="x"),"2.5","") generates the value 2.5 in cell T2
=IF(OR(M2="x"),"2.5","") generates the value 2.5 in cell U2
=IF(OR(N2="x"),"2.5","") generates the value 2.5 in cell V2
=IF(OR(O2="x"),"2.5","") generates the value 2.5 in cell W2
I would like to sum total the values in cells Q2:W2 when "X" is not entered in any of the cells in the range I2:O2.
For example ... there is no "X" in cell O2. This renders an error value in G2. [See Image #3]
(Image #2: Sum total works fine which is illustrated in #1)
Question: What is the formula required in cell G2 to sum total the cells in range Q2:W2 when an "X" is missing in any of the cells in range I2:O2?
Image attached for illustration.