Thread: Excel - Adding positive or negative numbers in a column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default Excel - Adding positive or negative numbers in a column
hi
try this....
=SUMIF(A1:A100,"0")

regards
FSt1

"skygazer" wrote:

How do I add only the positve numbers in a column with both positive and
negative numbers?
Reply With QuoteReply With Quote