I need to calculate the sum of the profit but ignore cell that have "-0.31" number in them
my formula is:
- Code: Select all
=SUMIF(J2:J199,"<>-0.31")
what do i do wrong?? Some help please. Unfortunately, the "-0.31" it's still calculated in this formula..