= 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

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