how do i make negative numbers equal zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to a minimum value of zero if a negative number 2
subtract a positive from a negative 7
Match and delete rows on two different sheets from reference numbers 4
I have a column of 50 numbers 1
Sum of a range of absolute numbers 4
make a negative number zero 5
Rounding Negative Numbers to Zero 4
How to count the maximum number of consecutives? 9

Back
Top