SumIF using Contain
I am trying to write a formula to sum a column if a criteria in another column is met.
Column to sum : Amount
Criteria column name : Status
Criteria to be met: Completed
I am trying =SUMIF(Status:Status, CONTAINS "Completed", Amount:Amount) but getting #UNPARSEABLE ERROR.
Also, is it possible to include multiple criteria from multiple columns?
Example: Sum of column Amount, if Status column contains "Completed, if Quarter column contains "Q1, if Budget column contains "Fixed". If all these 3 criteria are met, then sum the column Amount.
I am new to Formulas in Smartsheet. Please can someone help.
Help Article Resources
Check out the Formula Handbook template!