= SUMIF(OR.......

Answered - Pending Review

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 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.



  • Bassam.M KhalilBassam.M Khalil ✭✭✭✭✭
    edited 02/23/21

    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

    Best Regards

    Bassam.M Khalil

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as the accepted answer. It will make it easier for other Smartsheet Community members to find this solution or help to answer their questions.

  • Hi @Bassam.M Khalil

    Thank for your fast support, here the screen shot

    In White = SHEET DATA

    in Yellow = SHEET RESULT

    Thanks you again.


Sign In or Register to comment.