SUMIF using or & and & contains

Cyndi

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".

Paul Newcome

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

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")))