ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUm (https://www.excelbanter.com/excel-worksheet-functions/221846-sum.html)

shah

SUm

Hai

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

rgds

Bernard Liengme[_3_]

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

David Biddulph[_2_]

SUm

=SUMIF(A1:A20,"0")
=SUMIF(A1:A20,"<0")
--
David Biddulph

shah wrote:
Hai

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

rgds

Fred Smith[_4_]

SUm

If it's the whole column you want to sum, use:
=sumif(a:a,"0")
=sumif(a:a,"<0")

Regards,
Fred.

"shah" wrote in message
...
Hai

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

rgds

All times are GMT +1. The time now is 04:47 PM.