Formula for Checkbox

Kashmala Zaman

Hi,

I need to create a formula for the highlighted field that shows the 'Amount in LC($)' of orders that do not have a check box checked on data sheet. This table below is on a separate sheet from the data.

The date sheet

Thanks

Paul Newcome

You would continue with the same "range, criteria" syntax.

=SUMIFS({Amount Column}, {Checkbox Column}, @cell <> 1, {Month Column}, @cell = 8)

Paul Newcome

Try...

=SUMIFS({Amount Column}, {Checkbox Column}, @cell <> 1)

Kashmala Zaman

Thanks, but how do I add the month column as well ?

Paul Newcome

You would continue with the same "range, criteria" syntax.

=SUMIFS({Amount Column}, {Checkbox Column}, @cell <> 1, {Month Column}, @cell = 8)