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

TMA55

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!

Find more posts tagged with

Accepted answers

All comments

Leibel S

@TMA55

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

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)

TMA55

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

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)

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.