# Can a sum ignore negative values?

1. ## Can a sum ignore negative values?

Is there a way that I can add 2 cells together but whereby it will ignore a cell if the number is a negative result?

For example, in cell A1 I have the number 88, in B1 I have -60. In C1, rather than it return a result of 28 (as it is doing) I would want it to return the number 88

2. ## Re: Can a sum ignore negative values?

Something like =SUMIF(A1:A10,">=0")

3. ## Re: Can a sum ignore negative values?

Formula:
`Please Login or Register  to view this content.`

4. ## Re: Can a sum ignore negative values?

thanks both, I knew it would be something straightforward but I just couldn't get it to work

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1