Adding only positive numbers
 

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

Adding only positive numbers
 

Try this:

=SUMIF(A1:A10,"0")

Biff

"Eric" wrote in message
...
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

Adding only positive numbers
 

hi,
look up sumif.

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

regards
FSt1



"Eric" wrote:

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