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.

Two audit cells display the SUM ranges and highlight the shorter C range.

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.

After checking C6, the audit shows the corrected range C2:C6.

Illustrated correction. The formula text and total update together.

Microsoft’s FORMULATEXT function reference