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
-
Hi @Michelle Maas
Hope you are fine, please try the following formula:
=SUMIFS(Amount:Amount, [Billable to Client?]:[Billable to Client?], 1)
☑️ 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"
Answers
-
Hi @Michelle Maas
Hope you are fine, please try the following formula:
=SUMIFS(Amount:Amount, [Billable to Client?]:[Billable to Client?], 1)
☑️ 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"
-
Thank you @Bassam Khalil, that works great.
-
You are welcome and I will be happy to help you any time.
☑️ 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
Categories
Check out the Formula Handbook template!
