At 12:01 09/10/2007 -0600, Ralph Noname wrote:
How can I modify this formula =sumif(b5:d5;"<0";(b5:d5) so that if
b5+c5+d5 is a negative number I will get (what I want) the actual
negative sum and not just the sum of the negative numbers? B5 is a
positive number.
SUMIF totals just some of the values, depending on the conditions you
specify. But you say you do not want this. Don't use SUMIF!
What do you want if the value is not negative? Let's imagine you
want zero in this case. Try
=MIN(SUM(B5:D5);0)
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
