How do I sum up one column if a checkbox in another column is checked?

How do I add up all amounts in column "Interest Level" if column "Paperwork Sent?" is checked?

The closest I've got is:

=SUMIF([Interest Level]:[Interest Level], [Paperwork Sent?]:[Paperwork Sent?], 1)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!