"Mark74w1" wrote:
Subject: Are the parentheses the problem?

Yes, that is the problem, for the most part. Try the following:

=(U14
-(SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320)
+SUMIF('Cost Plus Invoice'!O8:O1510,"m",'Cost Plus Invoice'!T8:T1320)
+SUMIF('Cost Plus Invoice'!O8:O1510,"r",'Cost Plus Invoice'!T8:T1320)
+SUMIF('Cost Entry'!O7:O1320,"t",'Cost Entry'!T7:T1320)
+SUMIF('Cost Entry'!O7:O1320,"m",'Cost Entry'!T7:T1320)
+SUMIF('Cost Entry'!O7:O1320,"r",'Cost Entry'!T7:T1320)
+Phases!L29))*0.55+'Profit & Loss'!U15

Even simpler:

=(U14
-SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320)
-SUMIF('Cost Plus Invoice'!O8:O1510,"m",'Cost Plus Invoice'!T8:T1320)
-SUMIF('Cost Plus Invoice'!O8:O1510,"r",'Cost Plus Invoice'!T8:T1320)
-SUMIF('Cost Entry'!O7:O1320,"t",'Cost Entry'!T7:T1320)
-SUMIF('Cost Entry'!O7:O1320,"m",'Cost Entry'!T7:T1320)
-SUMIF('Cost Entry'!O7:O1320,"r",'Cost Entry'!T7:T1320)
-Phases!L29)*0.55+'Profit & Loss'!U15

However, multiplying dollar-and-cents by 0.55 is risky: often, the result
is not exact to the penny. For example, 1.23*0.55 is 0.6765. If you
display with only 2 decimal places, it will __look__ like 0.68. But it is
still __really__ 0.6765. That might adversely affect dependent calculation
elsewhere.

So the best formula is:

=ROUND((U14
-SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320)
-SUMIF('Cost Plus Invoice'!O8:O1510,"m",'Cost Plus Invoice'!T8:T1320)
-SUMIF('Cost Plus Invoice'!O8:O1510,"r",'Cost Plus Invoice'!T8:T1320)
-SUMIF('Cost Entry'!O7:O1320,"t",'Cost Entry'!T7:T1320)
-SUMIF('Cost Entry'!O7:O1320,"m",'Cost Entry'!T7:T1320)
-SUMIF('Cost Entry'!O7:O1320,"r",'Cost Entry'!T7:T1320)
-Phases!L29)*0.55+'Profit & Loss'!U15, 2)

Caveat: That assumes that each of those cells are constants or their
formulas have been rounded to 2 decimal places.


----- original message -----
"Mark74w1" wrote:
The formula is to show t's Share of the profit.

=SUM(U14)-((SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus
Invoice'!T8:T1320))+((SUMIF('Cost Plus Invoice'!O8:O1510,"m",'Cost Plus
Invoice'!T8:T1320))+((SUMIF('Cost Plus Invoice'!O8:O1510,"r",'Cost Plus
Invoice'!T8:T1320))+((SUMIF('Cost Entry'!O7:O1320,"t",'Cost
Entry'!T7:T1320))+((SUMIF('Cost Entry'!O7:O1320,"m",'Cost
Entry'!T7:T1320))+((SUMIF('Cost Entry'!O7:O1320,"r",'Cost
Entry'!T7:T1320)))+(Phases!L29)*0.55+('Profit & Loss'!U15))))))
Payments by customer: $2587.11
Total cost of the project: - $1178.68
__________
Total Profit: $1408.43

"t"'s Share (55%) of the profit: x.55= $ 774.77
Plus the amounts paid by "t" $ 928.43
_________
"t"'s total sha $1703.20

=SUM(U14 is $2587.11
=SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320
is $ 422.11
=SUMIF('Cost Plus Invoice'!O8:O1510,"m,'Cost Plus Invoice'!T8:T1320
is $ 150.00
=SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320
is $ 100.00
=SUMIF('Cost Entry'!O8:O1510,"t",'Cost Entry'!T8:T1320 is $
377.36 =SUMIF('Cost Entry'!O8:O1510,"m",'Cost Entry'!T8:T1320 is $
000.00
=SUMIF('Cost Entry'!O8:O1510,"r",'Cost Entry'!T8:T1320 is $ 000.00
+(Phases!L29 is $128.96 [payroll]
+('Profit & Loss'!U15 is $928.43 [paid by "t"

Why is this formula not working even when excel corrects it?