Sumifs with multiple criteria

Options

I am trying to sum the Open amount on another sheet if it meets 2 criteria. If the dispute box is checked in a column and if there is a 1 in the FM PO column. Here is are the formulas I have tried this far with no luck:


=SUMIF({Medxcel Fire Invoices Range 5}, OR(CONTAINS(1, {Medxcel Fire Invoices Range 4}), CONTAINS(1, {Medxcel Fire Invoices Range 1}))) - this formula is coming back as 0 and I know it is not 0.

=SUMIFS({Medxcel Fire Invoices Range 5}, {Medxcel Fire Invoices Range 4}, 1, {Medxcel Fire Invoices Range 1}, 1) - this formula is coming back as 0 and I know it is not 0.

Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!