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


"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