At a booth, each restock is recorded on a separate line. Enter Category and Units in A1:B1, then Posters 7, Pins 10, Posters 5 and Pins 4. Keep the numbers in B2:B5 and leave running totals outside the range.

Ask for units by category

Select A1:B5 in Ulet and choose Data → PivotTable. Put Category in Rows and Units in Values. Use Sum and choose an empty destination, such as F1 on the same sheet.

The booth log lists Posters 7, Pins 10, Posters 5 and Pins 4.

Illustrated PivotTable source. Use a single header row and numeric quantities.

Match every number to the log

Add the source rows by hand once. Pins total 14, posters total 12 and the overall number is 26. If each row says 2, inspect Count versus Sum and check the type of the Units cells. After reopening the XLSX, confirm the source range before refreshing new restocks.

The pivot shows Pins 14, Posters 12 and a grand total of 26.

Illustrated reconciliation. A result of 2 per category would count the records.

Related Microsoft Excel reference