Hmmmmmm

What's the expression KISS
Yes it does well spotted :)

Mike


"Sandy Mann" wrote:

Mike,

Doesn't your formula work just as well without the MIN() function?

=IF(ISBLANK(B6:E6),"",SUM(IF(B6:E6<0,B6:E6,FALSE)) )

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Mike H" wrote in message
...
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!