SUMIF using or & and & contains

Options

I am needing to sum the Estimated Budget for everything that has a Status of "Proposal with Client" or "Sales Order with Client for Signature" AND if the Session-Service column contains "Assessment" or "Test".


Tags:

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    You are going to want something like this...


    =COUNTIFS(Status:Status, OR(@cell = "Proposal with Client", @cell = "Sales Order with Client for Signature"), [Session-Service]:[Session-Service], OR(@cell = "Assessment", @cell = "Test"))

  • Cyndi
    Cyndi ✭✭
    Options

    Thank you, but I need it to sum the Estimated Budget column if the Status is "Proposal with Client" or "Sales Order with Client for Signature" AND if the Session-Service column contains either "Assessment" or "Test". Here is what I have but it isn't working.

    =SUMIFS([Estimated Budget]:[Estimated Budget], Status:Status, OR(@cell = "proposal with client", @cell = "sales order with client for signature"), AND([Session-Service]:[Session-Service], OR(@cell="assessment", @cell="test")))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!