CODEWITHSUNDEEP
excelif-statementsum
maxxi
maxxi

Reputation: 19

SUMIF ignore negative number

don't know how to solve this problem I am hitting my head into the wall for awhile now.... I need to calculate the sum of the profit but ignore cells that have "-0.31" number in them

my formula is:

=SUMIF(J2:J199,"<>-0.31")

what do I do wrong?? Some help, please. Unfortunately, the "-0.31" it's still calculated in this formula.

Upvotes: 0

Views: 591

Answers (2)

Slai
Slai

Reputation: 22896

You can use two separate SUMIF:

=SUMIF(J2:J199,"<-0.315")+SUMIF(J2:J199,">=-0.305")

or

=SUMPRODUCT(J2:J199*(ROUND(J2:J199,2)<>-0.31))

Upvotes: 1

Vinnie
Vinnie

Reputation: 553

How about:

=SUMIF(J2:J199,"<>"&-0.31)

Upvotes: 0

Related Questions