Adding only positive numbers

E

Eric

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
 
F

FSt1

hi,
look up sumif.

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

regards
FSt1
 
Top