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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!