# 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.

• ✭✭✭✭✭
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.

• ✭✭✭✭✭
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.

• Options

Hi Devin, thank you

```so i tried your formula but it's not working. Here is what I typed out
```

Help me, please. and thank you

``` =if(Scope@6=1,Qty@6*cost@6,"")
```

• Options

=IF(Scope@row = 1, Qty@row * Cost@row)

• Options

got it! thank you

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!