Excel Help?

[dyzfunctioned]

So usually pretty good with excel but I'm baffled about what my spreadsheet is doing...

I'll start off by trying to explain it in basic terms, then go more in depth.

So basically I have a spreadsheet set up with 3 reference tables - incoming, outgoing, deductions. Basically the calculation I'm trying to do is...

Incoming + Outgoing - Deductions = Result

However, for some reason when I change the value in outgoing, the result remains the same.

Automatic calculations is enabled etc. and all my other formulas work perfectly.

Now more in depth...

Exact calculation (ie: Formula) I'm trying to make is:

=(J60+J123-056)-(I60+I123-N56)

J60 =IF((I56-J56)<0,0,(I156-J56))
J123 =IF((J119-I119)<0,0,(J119-I119))
056 =SUM(O5:O47)
I60 =IF((J56-I56)<0,0,(J56-I56))
I123 =IF((I119-J119)<0,0,(I119-J119))
N56 =SUM(N5:N47)

J119 =SUMIF(J4:J55,1,K4:K55)
I119 =SUMIF(I4:I55,1,K4:K55)

I123 and J123 are same idea.

J4/I4:J55/I55 are just numbers.

Basically...

J60=4663.98 + J123=0 - O56=4303.26 = 360.72
When I change a value (ie:J50), then J60 updates to reflect this change. However, this change doesn't carry through the formula.

Ie: in above example where the outcome is 360.72, if if a change causes J60 to change to 4913.98, the end result remains 360.72 rather than 610.72

Don't know if anyone has an idea but it's driving me crazy so I figured I'd post.

[dyzfunctioned]

I figured it out so y'all can just ignore this,