Help using OR in SUMIFS

nadiasmartsheet

I cannot figure out how to change this formula so it will add up amounts in the Stage Column that has a dropdown with several options. 

Right now, the below works, but I want it to work when the Stage is Verbal Commitment OR Written Commitment.

=SUMIFS([Committed $]9:[Committed $]64, [Current Campaign Name]9:[Current Campaign Name]64, "USAID match", Stage9:Stage64, "Verbal Commitment")

 

I'm out of guesses as to how to add that in!

Mike Wilday

You can use basic math functions to add two SUMIFS together. Because SUMIFS does not allow OR or AND filters in the functions, you will have to add the two sumifs together like this: 

=SUMIFS([Committed $]9:[Committed $]64, [Current Campaign Name]9:[Current Campaign Name]64, "USAID match", Stage9:Stage64, "Verbal Commitment")+SUMIFS([Committed $]9:[Committed $]64, [Current Campaign Name]9:[Current Campaign Name]64, "USAID match", Stage9:Stage64, "Written Commitment")