SUMIFS CHILDREN WITH MULTIPLE CRITERION

Good morning,

I need to sum all of the children except those that say "Paid" and/or "Void". I'm stuck in adding more than one option. Any help will be greatly appreciated. Thank you so much!

=SUMIFS(CHILDREN(AMOUNT@row), CHILDREN(STATUS@row), @cell <> "PAID")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!