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)
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"
Answers
-
Hi @Michelle Maas
Hope you are fine, please try the following formula:
=SUMIFS(Amount:Amount, [Billable to Client?]:[Billable to Client?], 1)
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"
-
Thank you @Bassam Khalil, that works great.
-
You are welcome and I will be happy to help you any time.
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"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!