# Function for summing just positive resp. negative values in a column

#### Kribulin

##### Board Regular
How can I choose to just sum the positive (respectively just the negative) values of a column containing a mixture of both?

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

##### MrExcel MVP
how Can I Choose To Just Sum The Positive (respectively Just The Negative) Values Of A Column Containing A Mixture Of Both?

Try...

=SUMIF(A:A,">0")

=SUMIF(A:A,"<0")

Last edited:

=SumIf(A:A,">0")
=SumIf(A:A,"<0")

?

#### Mike Blackman

##### Well-known Member
HI,

=SUMIF(A1:A20,">0")

#### Kribulin

##### Board Regular
Thanks!

Thanks for all the fast responses!

Replies
0
Views
195
Replies
1
Views
100
Replies
5
Views
190
Replies
1
Views
95
Replies
3
Views
918

1,191,555
Messages
5,987,257
Members
440,086
Latest member
Mahi786

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back