Thread: Excel - Adding positive or negative numbers in a column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
  
Posts: 921
Default Excel - Adding positive or negative numbers in a column
=SUMPRODUCT((A1:A15)*(A1:A150))

A1:15 represents whatever your range is.

I like sumproduct because it is intuitive, showing you your conditions, ie
greater than zero or positive.

"skygazer" wrote:

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