[users] Re:

[mat1500]

Erik,

Thank you for the answer.  That formula works find!

Ralph
  ----- Original Message ----- 
  From: Erik Remmelzwaal 
  Cc: users@openoffice.org ; mat1500 
  Sent: Wednesday, October 10, 2007 3:11 PM
  Subject: Re: 


  The result of the =SUMIF(..) when all numbers are >0 is 0. So just a SUM(..) 
is not sufficient. I guess you need something like
  =IF( SUM(...) < 0; SUM( ...); 0)

  Erik

   said the following on 8:59 PM: 
    &lt;div class="moz-text-flowed" style="font-family: -moz-fixed"&gt;Ralph: 
Please respond only to the list (users@openoffice.org), not to me 
    directly. That way, others can also help if needed.
    <br>
    <br>In this case, it sounds like the solution is simple, if I understand 
    things. You don't want to do a "SUMIF". You just want a simple "SUM". So 
    it would be =SUM(B5:D5)
    <br>
    <br>It's not clear why you originally wrote the formula using the SUMIF 
    function, but maybe there's still something I'm missing.
    <br>
    <br>mat1500 wrote:
    <br><blockquote type=cite>Richard,
    <br>
    <br>Sorry I didn't make myself clearer.&nbsp; b5=2 c5=-9 d5=2&nbsp; The sum 
is&lt;0 so 
    the sum I expect is -5.&nbsp; The formula =sumif(b5:d5;"&lt;0";(b5:d5) 
gives 
    the answer -9 which is the sum of the negative numbers.&nbsp; I would like 
    the answer to be -5.&nbsp; How do I change the formula?&nbsp; Any help 
greatly 
    appreciated.&nbsp; I will also send this answer to users in hopes of an 
    answer.
    <br>
    <br>Thank you greatly for your answer.
    <br>
    <br>Ralph
    <br>----- Original Message ----- From: "Richard Detwiler" &lt;[EMAIL 
PROTECTED]&gt;
    <br>To: &lt;users@openoffice.org&gt;
    <br>Cc: &lt;[EMAIL PROTECTED]&gt;
    <br>Sent: Tuesday, October 09, 2007 7:52 PM
    <br>Subject: Re: [users] spreadsheet
    <br>
    <br>
    <br><blockquote type=cite>mat1500 wrote:
    <br><blockquote type=cite>How can I modify this formula 
=sumif(b5:d5;"&lt;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?&nbsp; B5 is a 
    positive number.&nbsp; I am registered and I still have been unable to 
    get an answer to any of my questions.&nbsp; Please let me know what I am 
    doing wrong.
    <br>
    <br>Ralph
    <br>
    <br>
    <br></blockquote>
    <br>It's not clear to me specifically what you are looking for in the 
    result. I don't quite understand the difference between "the actual 
    negative sum" and "the sum of the negative numbers". Maybe if you 
    including some actual numerical examples, I and others could help you 
    figure out what formula would do what you're after.
    <br>
    <br>
    <br></blockquote>
    <br>
    <br></blockquote>&lt;/div&gt;
    <br></body>
    </html>
    </html>