# Premium Excel Course Now Available!

## 45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!

## SUMIF to ignore a negative number

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

### SUMIF to ignore a negative number

Hi don't know how to solve this problem i am hitting my head into wall for awhile now....
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..
• 0

crst
Rookie

Posts: 1
Joined: May 19, 2017
Reputation: 0
Excel Version: 2013

### Re: SUMIF to ignore a negative number

Hi crst, this forum is closing soon, please ask all future questions on the forum at https://www.teachexcel.com/talk/microsoft-office
• 0

Don
Moderator

Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010

Return to General Excel Questions

### Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 5 guests