SUMS and IF Formulas

LisaPetersonBW

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

Devin Lee

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

Devin Lee

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

LisaPetersonBW

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,"")

LisaPetersonBW

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

LisaPetersonBW

got it! thank you