how to summarize values in a row using if then and sum statements

Jerry Corpening
edited 08/17/22 in Formulas and Functions

In the below table, I want to sum the total spend according to the contract number and subtract that value from the contract amount. In my formula I get an "#UNPARSEABLE" error message. This is my formula: =IF([Contract Number]@row]),=([Contract Number]@row]),then SUM([Contract Amount]@row])-SUM([Total Spend]@row])

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!