View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Negative value to positive

"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)