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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!