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?
Help Article Resources
Check out the Formula Handbook template!