How do I use the SUMIFS function with the OR function?


I am trying to sum the total of amounts listed in column 1 if a specific name is in column2, or column3, or column4, or column5, or column6 AND the column7 ="won".

Names can be listed in multiple columns in a single row. I want to avoid double counting an amount.

I cannot seem to find a similar formula but I read it is possible to use the "OR" function within a "SUMIFS" function.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!