SUMS and IF Formulas

Options

Hi

I need a formula that sums up the value of children that are checked off in my sheet. I hope i am making sense.

So i have a sheet 4 columns, qty x cost. this produces a sum then a column that has check boxes, i only want the formula to sum up those those cells that have been checked off.

I hope I am explaining it correctly.

Thank you in advance

Best Answer

  • Devin Lee
    Devin Lee ✭✭✭✭✭
    Answer ✓
    Options
    =if(checkbox@row=1,qty@row*cost@row,"")
    

    You'll need to use the column names in place of what I wrote. After it is working how you want you can right-click on the cell and convert it to a column formula so it works on the whole column.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!