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. I am registered and I still have been unable to get an answer to any of my questions. Please let me know what I am doing wrong.
Ralph
