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)))
Help Article Resources
Check out the Formula Handbook template!