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

Find more posts tagged with

Accepted answers

Leibel S

@darrink

See below proper syntax for using the OR() function

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

Paul Newcome

You will need to remove the opening parenthesis before the second "@cell" reference and insert a comma between the end of the OR function and the start of the last range.

All comments

Leibel S

@darrink

See below proper syntax for using the OR() function

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

Paul Newcome

You will need to remove the opening parenthesis before the second "@cell" reference and insert a comma between the end of the OR function and the start of the last range.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.