IF and SUMIF
So this is what I want to do...
Sum of all negative numbers in range, if there are no negative numbers in
range display 0, if cells in range are blank display "". I tried using
something like this:
IF(B6:E6="","",SUMIF(B6:E6,<0,B6:E6))
Not sure how to do this, hope you can help!
|