SUMIF function

[Mark Dvorkin]

I have in column A negative and positive values.
I'd like to sum-up all negative values in that column in a given range
(say A2:A5)
using SUMIF() and place the result in a cell D20:

A
-3
-1
-5
2
-4
-22
12

I attempted to SUMIF(A2:A5, (A2:A5)<0, A2:A5)
The function returns zero, but silly me expected -10

Any help is greatly appreciated,
/mark

-

 

[Vasant Nanavati]

=SUMIF(A2:A5,"<0")