SUMIFS AND & OR

DTreacy

I am trying to sum a single column with the following conditions:

Year = 2018

AND

Division = North

AND

Project Status = Client Approvel

OR Project Status = Business Case Submitted

OR Project Status = Under Development

=SUMIFS([Net Project Savings]10:[Net Project Savings]1549, [Year Final Business Case Submitted]10:[Year Final Business Case Submitted]1549, "2018", Division10:Division1549, "North", [Project Status]10:[Project Status]1549],  OR(Project Status]10:[Project Status]1549] = "Client Approved", ([Project Status]10:[Project Status]1549] = "Business Case Submitted",  [Project Status]10:[Project Status]1549] = "Under Development"))

The above formula returns unparseable - ugh!

Thank you very much!!

Dave Stanley

To accomplish this you would need to use the @cell option and the OR() function to evaluate the Project Status.  For example:

=SUMIFS([Net Project Savings]10:[Net Project Savings]1549, [Year Final Business Case Submitted]10:[Year Final Business Case Submitted]1549, "2018", Division10:Division1549, "North", [Project Status]10:[Project Status]1549, OR(@cell = "Client Approval", @cell = "Business Case Submitted", @cell = "Under Development"))