To **count negative values** you can use `=COUNTIF(A1,"-*")`

To count for a *specific month* `=IF(MONTH(B1)=1,COUNTIF(A1,"-*"),0)`

this will put a 1 for any negative value for `month=1`

(january). You can change the `month = value`

for your month and you will get a column of 1s and 0s when you drag it down `column C`

(helper column)

At the end of the helper column you can `=sum(C:C)`

to **count the number of negative values for a given month**

of if you want to calculate the sum of the negative values `=SUMIF(C:C,"=1",A:A)`

Basically, what we're doing is using a *helper column* in `column C`

. You can hide this column and do your `=sumif`

or `=if`

somewhere in `Column D`

if you don't want the *helper column* to show.

## edit

Changed the `countif`

to count if it has a minus sign in it as the <0 won't work for non-numbers - should work