Sum formula needs to be zero if not positive
Closed
LJ
-
Jul 25, 2010 at 09:20 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Sum formula needs to be zero if not positive
- Count formula in excel excluding zero ✓ - Forum - Excel
- Sumif formula to sum between 2 dates...help ✓ - Forum - Office Software
- Need a formula to sum a column with #Value error ✓ - Forum - Excel
- Excel Formula to show Zero ✓ - Forum - Excel
- Excel formula if color is red then sum ✓ - Forum - Excel
1 reply
rizvisa1
Jul 25, 2010 at 03:41 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jul 25, 2010 at 03:41 PM
use if statement
=if(sum(b:b) <0,"", sum(b:b))
=if(sum(b:b) <0,"", sum(b:b))
