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

Jerry Corpening

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])

Jerry Corpening

Tomasz,

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

Tomasz Giba

Hi @Jerry Corpening

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!

Jerry Corpening

Tomasz,

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