how do i make negative numbers equal zero

B

benny1

I have a sheet set up with formulas, and i need a coloumn to sum up with only
the positive number in it.

example, i need:
4+6+-2+2
to equal 12

any sugestions
 
D

Dave F

I would create a helper column which tests each value to insure that it is
positive, and, if not, sets a new value of zero and then sum that column.

Example: =IF(A2<0,0,A2) and fill down (say in column B)

Then sum column B.

Dave
 
E

Elkar

For this example, I'll assume your data is in A1:A4.

=SUMIF(A1:A4,">0",A1:A4)

Adjust the range to meet your needs.

HTH,
Elkar
 
Top