Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF function
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 - |
#2
|
|||
|
|||
=SUMIF(A2:A5,"<0")
-- Vasant "Mark Dvorkin" wrote in message ... 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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
how do you do a sumif function on more than one worksheet? | Excel Worksheet Functions |