Sum when the Checkbox is not check.
Hello,
I am currently using a formula to sum the amount in the value cell.
=SUMIFS([Amount after Change]:[Amount after Change], Status:Status, "OUT - to the next month")
I want to extend the formula to only count when the Archive checkbox is not checked. Thanks for your help.
Best Answer
-
Hey @Kashmala Zaman
An unchecked box has a value of zero or false. A checked box = 1.
=SUMIFS([Amount after Change]:[Amount after Change], Status:Status, "OUT - to the next month", Archive:Archive, 0)
Will this work for you?
Kelly
Answers
-
Hey @Kashmala Zaman
An unchecked box has a value of zero or false. A checked box = 1.
=SUMIFS([Amount after Change]:[Amount after Change], Status:Status, "OUT - to the next month", Archive:Archive, 0)
Will this work for you?
Kelly
-
@Kelly Moore Thanks a lot, it works :)
-
Hello, I'm looking for a little additional help, I'd want to keep track of the value of orders that haven't been sent for invoicing in the cell in front of Open order.. The value should reflect total sales, excluding orders that are checked in 'Submitted for invoicing' column.
For your information, this is the formula used to compute the total sale value for the current month.
Thank you.
=SUMIFS([Amount in LC]:[Amount in LC], [Current ETA]:[Current ETA], MONTH(@cell) = MONTH(TODAY()))
-
Hi @Kelly Moore , could you please help with the above query. Thanks.
-
Hey Kashmala
Happy to help but I'm not sure I'm following what you need. Are you saying you want to modify your Current Month Sale formula to exclude the values that have a checkmark in your [Submitted for Invoicing] column?
-
Hi Kelly, I figured it out. No, I actually wanted to sum orders which have not been sent for invoicing yet. This is the formula I used.
=SUMIFS([Amount in LC]:[Amount in LC], [Current ETA]:[Current ETA], MONTH(@cell) = MONTH(TODAY()), Invoiced:Invoiced, 0)
Thanks for your help.
-
Excellent! Great job!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!