Help with multiple condition 'IF' and sum of results from 'THEN' statement

I am looking to get help to create an 'IF' 'THEN' statement that states:

If: Text=Defect, Month=Sep, Year=2020)

THEN: Sum the dollar amount from a column X which is relative and in the same row as Text 'Defect'

Else: Leave blank

I've tried IF, THEN statements and INDEX and IF(AND and all give me errors. Any help is much appreciated.

Thank you!


  • Leibel S
    Leibel S ✭✭✭✭✭✭


    Can you post a screenshot of the data you are working with and where you need this formula to be?

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭

    =SUMIFS([Column X]:[Column X], Text:Text, "Defect", Year:Year, "2020", Month:Month, "Sept"

    Should work I believe if your sheet looks something like the one below (the sum line is where the above formula is found)

  • Thanks for the feedback! I tried the formula and unfortunately, it gave me an 'Unparsed' error.

    This is an example of the data. The formula is to calculate the 'Total Cost' per 'MRR Month' and 'MRR Year' per each 'Root Cause'. If the 'Root Cause' is 'Bad Plating - Dim', then I want to calculate the cost per month and year for all products with the 'Root Cause' of 'Bad Plating - Dim'. Hope that makes sense.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    It looks like you have some syntax issues in your formula. Give this a go...

    =SUMIFS({Reference Sheet Total Cost Column}, {Reference Sheet Root Cause Column}, @cell = "Bad Plating - Dim", {Reference Sheet Month Column}, @cell = 8, {Reference Sheet Year Column}, @cell = 2021)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!