I have a doc with numerous worksheets related to retail inventory, traffic,
each store's orders and a totals page. I want to total the quantity of a
particular item the store used during the month. Inventory and orders are
counted by lots (i.e., 50 per lot). I took last month's inventory + this
month's order - this month's inventory, (i.e.,
='invntry!c61+'ords09'!b156-'invntry'!c101), but I don't know if that's
right. I'm wondering if the amount of traffic the store had should be used
at all. Any help with the appropriate formula would be appreciated. Thanks!