= SUMIF(OR.......

Jerome Szurubura

Hi Smartsheet Community,

I wondering to know if it is possible to make a "SUMIF (OR.." : I explain:

In Sheet 1 = SHEETDATA

I have two columns with data (reference of product) and one with a number (size of reel)

As example:

LIGN1 : I can choose REF A in cell column1, REF B in cell column2, and 30 in column 3

LIGN2 : I can choose REF B in cell column1, REF D in cell column2, and 20 in column 3

...

My goal:

In Sheet 2 = SHEETRESULT

In this sheet with two columns: column 1 is REF, column 2 is the sumif. I want to obtain

REF A =30

REF B = 50

REF C = 0

REF D = 20

The formula: SUMIF( "ranges" SHEETDATA column1 OR column2; "condition" = REFA; "sum of" SHEETDATA column3)

How to make : search in column1 'OR' column2?

Thanks per advance for your support.

Jerome

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @Jerome Szurubura

Hope you are fine, could you please add a screenshot for your sheet so i can write for you the exact formula with your column's name and reference.

but as a quick answer, you can use the SUMIFS function for multiple criteria

Jerome Szurubura

Hi @Bassam.M Khalil

Thank for your fast support, here the screen shot

In White = SHEET DATA

in Yellow = SHEET RESULT

Thanks you again.

Jerome

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.