how to summarize values in a row using if then and sum statements
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

Tomasz,
This is exactly what I am looking to do...Thanks for your assistance
Answers

If I understood you correctly here is the formula:
=[Contract Amount]@row  SUMIF([Contract Number]:[Contract Number], [Contract Number]@row, [Total Spend]:[Total Spend])
Good Luck!
Tomasz Giba

Tomasz,
This is exactly what I am looking to do...Thanks for your assistance
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!