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?
--------------------------------------------------------------------
No comments:
Post a Comment