Quote:
Originally Posted by Claus Busch
Hi Mark,
Am Mon, 24 Jun 2013 19:53:10 +0100 schrieb Mark74w1:
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.
try:
=ABS(SUMIF('Cost Plus Invoice'!O8:O1500,"p",'Cost Plus
Invoice'!T8:U1500))
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
Can you help me again?
=SUMIF('Cost Plus Invoice'!O$8:O$1510,"t,m,r",'Cost Plus Invoice'!T$8:U$1510)
Does not work: this means if troy or Mark or Robert pays the bill.
Also:
=SUMIF('Cost Plus Invoice'!O$8:O$1510,"t" when 'Cost plus invoice!m$8:m1500,"p",'Cost Plus Invoice'!T$8:U$1510)
This means if o is "t" and "m" is p, then sum.
These two formulas would simplify my 9 page spread sheet.
Thanks Mark