New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

SUMIF to ignore a negative number

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

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 11 guests

cron