Inventory tracking

%3CLINGO-SUB%20id%3D%22lingo-sub-2945327%22%20slang%3D%22en-US%22%3EInventory%20tracking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2945327%22%20slang%3D%22en-US%22%3E%3CP%3EAttached%20is%20a%20spreadsheet%20I%20use%20to%20track%20inventory.%20I%20want%20to%20be%20able%20to%20add%20a%20date%20in%20a%20cell%20like%20%2212-1%22%20or%20%2211-15%22%20when%20I%20have%20completed%20the%20inventory%20up%20to%20that%20date%20and%20cannot%20work%20it%20again%20until%20the%20date%20I%20input%2C%20without%20it%20being%20calculated%20into%20the%20totals%20for%20each%20row%20and%20column%2C%20basically%20a%20null%20value%20for%20that%20cell%2C%20but%20keeping%20the%20date%20visible%20so%20I%20know%20when%20to%20follow%20up.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2945327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2946309%22%20slang%3D%22en-US%22%3ERe%3A%20Inventory%20tracking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2946309%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1213331%22%20target%3D%22_blank%22%3E%40PLeClaire%3C%2FA%3E%26nbsp%3BNot%20sure%20what%20I'm%20looking%20at%2C%20but%20perhaps%20the%20attached%20file%20shows%20what%20you%20want%20to%20achieve.%20Enter%20the%20%22date%22%20as%20a%20text%2C%20then%20the%20sum%20formulae%20will%20ignore%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPS%3A%20Could%20not%20resist%20cleaning%20up%20the%20schedule%20a%20bit%20and%20demonstrated%20a%20more%20effective%20way%20of%20using%20SUM.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Attached is a spreadsheet I use to track inventory. I want to be able to add a date in a cell like "12-1" or "11-15" when I have completed the inventory up to that date and cannot work it again until the date I input, without it being calculated into the totals for each row and column, basically a null value for that cell, but keeping the date visible so I know when to follow up.  

 

2 Replies

@PLeClaire Not sure what I'm looking at, but perhaps the attached file shows what you want to achieve. Enter the "date" as a text, then the sum formulae will ignore them.

 

PS: Could not resist cleaning up the schedule a bit and demonstrated a more effective way of using SUM.

Perfect! Thank you for your prompt reply. I knew there was a way to do it, but just couldn't figure it out. I have spent an hour every night for the last two weeks trying. It seems to be a simple solution, and I am very thankful for your help.