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