Short answer: Give each stocking a small budget, then list every stuffer on its own row with who it is for, the item, the price and whether it is bought. A SUMIFS shows the total per stocking, and a count of bought items per person shows which stockings still look empty.
Stocking stuffers are cheap one by one, which is exactly why they blow budgets. Ten small items at a few dollars each can cost as much as a main gift. A separate list with its own budget keeps them visible.
Two small tables are enough.
Spent: =SUMIFS(Stuffers!C:C,Stuffers!A:A,A2,Stuffers!D:D,TRUE)Items bought: =COUNTIFS(Stuffers!A:A,A2,Stuffers!D:D,TRUE)Status: =IF(D2<3,"Needs more",IF(C2>B2,"Over budget","Done"))Total stuffer spend: =SUM(C:C)Mix one useful thing, one treat and one small fun item per person: socks, lip balm, a favourite snack, batteries for a gift that needs them, a puzzle book, a small toy or a gift card. Buying a few of the same item for several people can save money.
Stuffers work best on the same sheet as your main gifts so one total shows the whole season. Add a Stocking column to your gift list, or keep the stuffer table on a tab next to it.
Whatever fits your overall budget. Many people set a small fixed amount per stocking and stick to it for everyone, which also keeps things fair between kids.
Three to six small items fills most stockings. The status formula above flags any stocking with fewer than three.
Yes. The Christmas gift tracker spreadsheet below includes a stocking stuffers list along with a 300 row gift list, per-person budgets, a holiday budget, an expense log, a card list and a countdown, for Google Sheets and Excel.
Contact: m0f@mail.grokbot.com | Machine-readable: llms.txt, llms-full.txt, tools.json, openapi.json | Source: GitHub