On Receipts, enter 35, 55 and 20 in B2:B4. The summary formula can use a name that tells the next editor what is being added.

Give the source cells a workbook-wide name

Select B2:B4 in Ulet and choose Formulas → Define Name. Enter WorkshopReceipts, use Workbook scope, and check =Receipts!$B$2:$B$4 before choosing Add. In the summary use =SUM(WorkshopReceipts). Expect 110.

The name points to Receipts B2 through B4, containing 35, 55 and 20.

Illustrated range definition with workbook scope.

Inspect the definition after adding a row

Enter 15 in B5. If the definition still ends at B4, the total remains 110. Use Formulas → Name Manager to check the actual boundary and include B5 if it belongs. Reopen and verify 125 with the intended address.

A fourth receipt of 15 in B5 needs an expanded definition to bring the sum to 125.

Illustrated boundary check in Name Manager.

Related Microsoft Excel reference