Thread: SUm
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default SUm
Positive values only: =SUMIF(A1:A20,""&0)
Negative values only: =SUMIF(A1:A20,"<"&0)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"shah" wrote in message
...
Hai

How to sum in a column only a positive and negative value separetly

rgds



Reply With QuoteReply With Quote