Formula to calculate amount if column checked

Michelle Maas
Michelle Maas ✭✭✭✭
in Formulas and Functions

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

Expenses.PNG


· Share on FacebookShare on Twitter

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

    bassam.khalil2009@gmail.com

    ☑️ 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"

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!