Help on SUMIF Formula not showing a negative value

I know this has to be something simple but my brain just can't get done this morning, so any help is greatly appreciated. I basically need a formula to take one cells value and minus another cells value if one cell is greater than 0. This is the formula ------- =SUMIF([Actual Device Tags]@row - [Quoted Device Tags]@row, [Actual Device Tags]@row > 0) ----- I have now and works great but if the delta between the two cells is a negative number it will only show up as a zero. How do i get it to show the true value whether its positive or negative?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!