# Column of values, some negative, how to sum the negatives?

#### terryc

##### Board Regular
I have a column of values, as follows:

27
21
45
64
-12
14
-54
-45
67
67

I'd like to create a formula that takes the column of values and produces a sum of all the negative figures automatically, e.g. in this case the answer would be -111.

Does anyone know how to do this?

Thanks!

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### Andrew Fergus

##### MrExcel MVP
Hi

Try using the sumif function - it does condition a conditional sum like you described. Check it out in your help file but the syntax looks like this :

=SUMIF(A1:A10,"<0")

Andrew

#### Richard Schollar

##### MrExcel MVP
Hi

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

assuming your values are in column A.

Replies
5
Views
184
Replies
4
Views
956
Replies
20
Views
720
Replies
22
Views
1K
Replies
5
Views
175

1,191,173
Messages
5,985,098
Members
439,940
Latest member

### 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