Calculate the total quantity sold per category in range D32:D51 based on the item in column B. Once this has been calculated, the total quantity delivered and ending inventory can be calculated. In cell D32, create a formula to sum the range Trans_Sold from the DailyTransactions worksheet if the criteria in B32 is found in the range Trans_Item from the DailyTransactions worksheet.

K10 X D F G H K L M N O P Q R S T V Projection Actual 0 5 0 15 6 6 0 B 1 Category Massage 2 Category Item 3 1 A9 4 2 A10 5 3 A11 6 4 A12 7 5 8 6 9 7 10 8 11 9 12 10 13 11 14 12 15 13 16 14 17 15 18 19 20 Categories 21 Massage 22 23 Food 24 Novelty 25 Reading 26 Clothing 27 28 29 30 Item 31 32 A1 33 A2 34 A3 35 A4 36 A5 37 A6 Mon Thur Sat Wed 0 Fri 0 15 Sun 0 0 0 Golf 0 0 Tues 18 0 14 11 4 0 0 0 0 7 6 0 0 0 0 0 14 0 0 6 25 0 0 23 17 0 0 12 0 0 0 Total in Ending Actual Turnover Description Beginning Total out inventory 35 33 48 10 52 101 Max Stock Inventory Discrepancy 25 On Target 20 On Target 15 On Target 10 On Target 30 On Target 30 On Target 0.00% Healthy Trail Mix 0.00% Resort Polo 0.00% Healthy Energy Bar 0.00% Spirits Lifted Through Yoga 0.00% Golf Tees 0.00% Inventory InventoryAudit DailyTransactions # Ready + 100%