Thread: Adding only the negative or positive numers in a column or row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MrAcquire MrAcquire is offline
external usenet poster
  
Posts: 62
Default Adding only the negative or positive numers in a column or row
To sum negative numbers only in a selected range,

=SUMIF(range,"<0")

To sum positive numbers only in a selected range,

=SUMIF(range,"0")

"slowes" wrote:

How do I add only the negative or only the positive numbers in a selected
range?
Reply With QuoteReply With Quote