Adding only positive numbers

[Guest]

I have a column of $ amounts (some negative) for which I would like to write
a function to add ONLY the positive numbers, and exclude the negative ones.
How can this be done.
-Eric

 

[T. Valko]

Try this:

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

Biff

 

[Guest]

hi,
look up sumif.

it might look something like this...
=sumif(c1:c10,">=0",c1:c10)

regards
FSt1