Help on SUMIF Formula not showing a negative value

Eric Aplin

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?

David Tutwiler

You're doing a SUMIF, so I think it's a problem with how you're using it. The format of SUMIF is (range, criterion). If all you're looking to do is return the value after the subtraction, I think you just need an IF.

=IF([Actual Device Tags]@row > 0, [Actual Device Tags]@row - [Quoted Device Tags]@row)

David Tutwiler

You're doing a SUMIF, so I think it's a problem with how you're using it. The format of SUMIF is (range, criterion). If all you're looking to do is return the value after the subtraction, I think you just need an IF.

=IF([Actual Device Tags]@row > 0, [Actual Device Tags]@row - [Quoted Device Tags]@row)

Eric Aplin

Hot diggity dog, you saved me from losing my mind and more hair off my head!! Greatly appreciated!!

David Tutwiler

No problem, glad it's working