New Excel Forum

This forum has been moved to

Ask all future questions in the New Excel Forum.


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

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

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
  • 0

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

Return to General Excel Questions

Who is online

Users browsing this forum: Google Adsense [Bot] and 16 guests