"adelaide" wrote:
hope this helps

Not really; there is no context: Where do these formulas go. Which two
cells display as 520.16 and 520.10 but add to 1040.15? ...

One observation is there is much unnecessary use of the SUM function
=SUM(D5*C41) can be written more simply as =D5*C41
=SUM(F5+E5) can be written more simply as =F5+E5
=SUM(C41)/2+C41 can be written more simply as =C41/2+C41
...
Only formulas like =SUM(D5:D24) really need the SUM function.

Jerry