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!
Answers

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

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

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
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!