Counting totals with checkbox rows


Hi there,

I am trying to set up a formula where it will add up all of the "buying price" column where "sold" is checked.

I want to see the total value of all sold units, based on the check box approach.

See attached image.

Can any body advise how to achieve this? I've been messing around now for a long time, and I cannot fathom it!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!