View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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