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

kahukusweet

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)

Carson Penticuff

Try this:

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

Carson Penticuff

Try this:

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

kahukusweet

Totally worked. Thank you!!