Formula to calculate amount if column checked


In the Summary Sheet, I want to calculate the total sum in the [Amount] column, but only if the [Billable to Client?] column is checked. I'm halfway there with a formula counting checked, but it is also counting unchecked. Please help me figure out how to exclude the unchecked amounts. Thank you.

=IF(COUNT([Billable to Client?]1), (SUM(Amount:Amount)))

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Michelle Maas

    Hope you are fine, please try the following formula:

    =SUMIFS(Amount:Amount, [Billable to Client?]:[Billable to Client?], 1)

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!