Thursday, June 23, 2011

yogi_Compute Items Brought And Remaining At Multiple Events

Google Spreadsheet
BTFish said:
I am trying to keep track of how many t-shirts I still have left in stock as they get sold at multiple events. Basically the total t-shirts ordered is subtracted from the t-shirts sold at each event. I am currently using a VLOOKUP function to provide this calculation as I would like to keep the different t-shirt sizes separate, but I can only get the formula to work for one event. Whereas I'd like it to work for all events as they get added to the spreadsheet. I believe I need an array formula to provide the proper function for multiple events?