Quote:
Originally Posted by joeu2004[_2_]
"Mark74w1" wrote:
This formula,
=SUMIF('Cost Plus Invoice'!O8:O1500,"p",'(Cost Plus Invoice'!T8:U1500)
copys (to the cell it is written to) the sum of negative
dollar amounts from another sheet. I need to add to this
formula, a formula that changes the negative dollar amount
total to a positive. I know that the abs function converts,
but i'm not sure how to incorporate it into this formula.
Use the ABS function if the SUMIF result might be negative __sometimes__,
positive other times.
However, if the SUMIF result is __always__ negative ("the sum of negative
amounts"), you can simply negate it, to wit:
=-SUMIF('Cost Plus Invoice'!O8:O1500,"p",'(Cost Plus Invoice'!T8:U1500)
|
Joe,
Thank you for the response on this problem.
For some reason, when I entered the corrected formula it opens my documents looking for a file.
The reply by Mr. Busch worked, however I still want to find out why this formula didn't work so that I could use it as well.
Thanks, Mark