Help using OR in SUMIFS
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!
Help Article Resources
Check out the Formula Handbook template!