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.

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.

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



