SumIfs with multiple values from same column

Options

I'm attempting to Sum $ based on several statuses in the Status Column, but can't figure out how to use multiple values.

I successfully used the below to sum for one status, but need to add 3 more statuses "Pending Mail Merge" , "Awaiting Calculation" and "Payment Received"

=SUMIFS([Amount of Bonus Owed to Company (Gross)]:[Amount of Bonus Owed to Company (Gross)], [Program Type]:[Program Type], "Sign-On Bonus", Status:Status, ="Pending Initial Notification")

Thanks in advance for your help!!

Tags:

Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓
    Options

    @AGorgei

    Something like this?

    =SUMIFS([Amount of Bonus Owed to Company (Gross)]:[Amount of Bonus Owed to Company (Gross)], [Program Type]:[Program Type], "Sign-On Bonus", Status:Status, OR(@cell="Pending Initial Notification",@cell="Pending Mail Merge",@cell="Awaiting Calculation",@cell="Payment Received"))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!