Sum if Question

DavosCH32

New Member
Joined
Jun 27, 2014
Messages
8
I'm not sure if this is possible, however I am trying to sum a row, but if the sum value drops below a 0 it should just be 0. If it's a positive, it should return the value of the row. =IF(A3="","",SUM(B3:C3))+D2 It's a daily continuing total so I just added the day before to the next day if that make sense.
I have tried it a couple of ways but I can't get it to work.


ABCD
1DateCreditsRoll OffTotal
2
01/01/20​
0.50​
-1.00​
-0.50​
3
01/02/20​
1.00​
-0.25​
0.25​
4
01/03/20​
1.00​
-0.50​
0.75​
5
01/04/20​
1.00​
-0.25​
1.50​
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,481
Office Version
365
Platform
Windows
How about:
=MAX(SUM(B3:C3))+D2,0)
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,481
Office Version
365
Platform
Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,138
Messages
5,472,743
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top