SUMIFS CHILDREN WITH MULTIPLE CRITERION

Lily Alvarez

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

Paul Newcome

Try this...

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

Paul Newcome

Try this...

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

Lily Alvarez

PAUL!!! That worked perfectly! THANK YOU SO VERY MUCH! You are a life saver!🤩

Paul Newcome

Happy to help! 👍️