New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

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

Postby crst » Fri May 19, 2017 5:24 am

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

Postby Don » Tue May 23, 2017 9:27 am

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: Google [Bot] and 3 guests

cron