Excel issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1760333%22%20slang%3D%22en-US%22%3EExcel%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1760333%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Excel%20I%20am%20trying%20to%20build%20a%20paper%20Inventory%20sheet%20I%20have%20a%20cell%20that%20I%20want%20to%20use%20as%20a%20lbs%20used%20cell%20so%20one%20day%20I%20enter%20100%20then%20maybe%20the%20next%20day%20I%20want%20to%20enter%20200%20in%20that%20same%20cell%20so%20the%20cell%20should%20read%20then%20as%20300%20can%20I%20do%20this%20somehow%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1760333%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-1760630%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1760630%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F825137%22%20target%3D%22_blank%22%3E%40chaskett%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20my%20humble%20opinion%2C%20this%20is%20not%20a%20good%20idea.%20You%20won't%20be%20able%20to%20correct%20mistakes%20since%20you%20can't%20see%20how%20the%20total%20was%20formed.%3C%2FP%3E%0A%3CP%3EI'd%20enter%20each%20weight%20in%20a%20separate%20cell%20and%20use%20a%20SUM%20formula%20to%20calculate%20the%20total%20weight.%3C%2FP%3E%0A%3CP%3EThat%20way%2C%20you%20can%20edit%20an%20incorrect%20entry%20afterwards.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

In Excel I am trying to build a paper Inventory sheet I have a cell that I want to use as a lbs used cell so one day I enter 100 then maybe the next day I want to enter 200 in that same cell so the cell should read then as 300 can I do this somehow?

1 Reply

@chaskett 

In my humble opinion, this is not a good idea. You won't be able to correct mistakes since you can't see how the total was formed.

I'd enter each weight in a separate cell and use a SUM formula to calculate the total weight.

That way, you can edit an incorrect entry afterwards.