On Tue, 25 Jun 2013 15:10:20 +0100, Mark74w1
wrote:


'joeu2004[_2_ Wrote:
;1612463']"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

Cell formatting negated it being seen as a formula?