sumif?

S

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
 
S

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)
 
S

Scott A

That worked great! Thank You!

Sheeloo said:
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)
 
S

Shane Devenshire

Hi,

Since you asked for any other suggestions:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top