How do i use OR function within SUMIFS function?

Im trying to use the OR function so i can get the total where criteria is met by one of 4 conditions. Can someone tell me the proper syntax? Below is my current formula:

=SUMIFS({Upcoming Jobs (High Level) Range 3}, {Upcoming Jobs (High Level) Range 1}, =[Job Name 1]@row , OR({Upcoming Jobs (High Level) Range 1}, =[Job Name 2]@row ), OR({Upcoming Jobs (High Level) Range 1}),=[Job Name 3]@row ), OR({Upcoming Jobs (High Level) Range 1},=[Job Name 4]@row ))

Find more posts tagged with

Accepted answers

jjg279

Hey Brandon, would this do the trick?

=SUMIFS({Upcoming Jobs (High Level) Range 3}, {Upcoming Jobs (High Level) Range 1}, OR(@cell = [Job Name 1]@row , @cell = [Job Name 2]@row , @cell = [Job Name 3]@row , @cell = [Job Name 4]@row ))

All comments

jjg279

Hey Brandon, would this do the trick?

=SUMIFS({Upcoming Jobs (High Level) Range 3}, {Upcoming Jobs (High Level) Range 1}, OR(@cell = [Job Name 1]@row , @cell = [Job Name 2]@row , @cell = [Job Name 3]@row , @cell = [Job Name 4]@row ))

Brandon Morales

perfect. that worked. thank you!!

jjg279

Most welcome!

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.