sumif?

[Scott A]

Hello,

I would like a formula the calculates a total as it is is the word "No" iis
in a cell and doubles the amount if that same cell says "Yes".

I J K L
M
32 Feet
Inches
33 How Many: 2 Length: 10 8
34 Open Beam: Yes Width: 12 3
35 Total SF:
?

Right now the formula that I have for cell M35 is:
=SUM((L33+(1/12*M33))*(L34+(1/12*M34))*J33)

What I would like it to do is double the answer is the word "Yes" in in cell
J34.
If you have a better formula to calculate the initial total, please feel
free to change it.

Can anyone help?

Thank you for any help you can give!
Scott A

 

[Sheeloo]

Try
=SUM((L33+(1/12*M33))*(L34+(1/12*M34))*J33) * IF(J35="Yes",2,1)

I have multiplied your formula by
IF(J35="Yes",2,1)
which will multiply the current result by 2 if J35 has the value Yes, and by
1 otherwise (giving you the current result)

 

[Scott A]

That worked great! Thank You!

Try
=SUM((L33+(1/12*M33))*(L34+(1/12*M34))*J33) * IF(J35="Yes",2,1)

I have multiplied your formula by
IF(J35="Yes",2,1)
which will multiply the current result by 2 if J35 has the value Yes, and by
1 otherwise (giving you the current result)

 

[Shane Devenshire]

Hi,

Since you asked for any other suggestions:

=((J34="Yes")+1)*SUM((L33+M33/12)*(L34+M34/12)*J33)