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
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!