Sum when the Checkbox is not check.

Kashmala Zaman

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.

Kelly Moore

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

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

Kashmala Zaman

@Kelly Moore Thanks a lot, it works :)

Kashmala Zaman

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()))

Kashmala Zaman

Hi @Kelly Moore , could you please help with the above query. Thanks.

Kelly Moore

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?

Kashmala Zaman

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.

Kelly Moore

Excellent! Great job!