IF and SUMIF
Thanks alot!
"Mike H" wrote:
Hi,
Enter the formula in a cell and while still in that cell tap
Ctrl+Shift+enter
Excell will add a set of curly brackets around the formula {} You can't type
these yourself.
Mike
"JBoyer" wrote:
I tried it, and what happens is, it displays 0 if there are no negatives, ""
if cells are blank, but not the sum if there are negatives to add. I think i
did it the way you wanted me to try, although I'm confused with what you
wanted me to do with the brackets.
"Mike H" wrote:
Try
=IF(ISBLANK(B6:E6),"",MIN(SUM(IF(B6:E6<0,B6:E6,FAL SE)),0))
Attay entered with Ctrl+Shift+Enter and Excel will put curly brackets around
it {}
Mike
"JBoyer" wrote:
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!
|