# Sum if sum of cell range is negative number

1. ## Sum if sum of cell range is negative number

Hi...need a formula that sets cell equal to zero if sum of cell range is negative , but if sum of cell range is 0 or higher than the solution is the sum of cell range.

eg. solution would be in d3

a3 b3 c3
-17 22 -9

d3 if sum of a3 to c3 = less than zero/negative,0 or if sum a3 to c3 is zero or higher/positive, sum of a3:c3
total is -4 so cell should be 0

a4 b4 c4
12 -14 26

d4
total is 24 so cell should be 24

Thanks

2. ## Re: Sum if sum of cell range is negative number

D3, copied down :

=MAX(0,SUM(A3:C3))

Regards
Bosco

3. ## Re: Sum if sum of cell range is negative number

Originally Posted by Bosco
D3, copied down :

=MAX(0,SUM(A3:C3))

Regards
Bosco
Fantastic, Thanks!

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