A supply log needs a stable table name so another editor can see where the total gets its numbers.

Create SupplyLog from the two-column range

In A1:B4 enter Item and Units, followed by Tape 4, Clips 7, and Tags 5. Select the range in Ulet and choose Insert → Table. Check the range and name the table SupplyLog, then choose Create.

A1:B4 includes unique Item and Units headings and three supply records.

Illustrated source range. Keep unrelated notes outside the table.

Compare a structured sum with the direct range

Outside the table, enter =SUM(SupplyLog[Units]) and compare it with =SUM(B2:B4). Both should give 16. If the formula fails, read the actual table and column names. Reopen and verify the saved result. Check the table boundary after adding later records.

SUM(SupplyLog[Units]) and SUM(B2:B4) both give 16.

Illustrated formula check. Use the column label as saved.

Microsoft’s reference for formatting an Excel table