I need help implementing the "OR" function for a SUMIF scenario


I want to sum what is in "Total Deal Value" when the status is either "Approved" or "Exception Approved".

There is something wrong with my syntax.... can someone help?

=SUMIF([Approval Status]:[Approval Status], OR(@cell ="Approved"), (@cell ="Exception Approved") [Total Deal Value]:[Total Deal Value])

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!