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
--
Brevity is the soul of wit.


"benny1" wrote:

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