Two weekly totals look plausible, but you need to check whether they cover the same rows. Show each formula in a nearby audit cell.
Read the range endpoints side by side
Put =FORMULATEXT(B7) in B9 and copy across to C9. B7 displays =SUM(B2:B6) and C7 displays =SUM(C2:C5). Widen the audit columns if the last references are cut off.

Illustrated audit. Read the last cell reference in each formula.
Check C6 before changing the total
If C6 is an ordinary entry that belongs in the total, change C7 to =SUM(C2:C6). Check that C9 now displays the longer range and that the total includes C6. As a control, point FORMULATEXT at a cell containing only a number. Expect an error because the cell has no formula.

Illustrated correction. The formula text and total update together.



