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.
Please help.
Thanks, Mark