Calculator

%3CLINGO-SUB%20id%3D%22lingo-sub-2862590%22%20slang%3D%22en-US%22%3ECalculator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2862590%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20find%20how%20I%20can%20use%20each%20cell%20as%20a%20calculator%20essentially.%20I'm%20making%20a%20financial%20spreadsheet%20and%20instead%20of%20using%20a%20calculator%20to%20add%20the%20totals%20from%20a%20website%20and%20then%20putting%20that%20new%20number%20in%20the%20cell%2C%20I%20would%20like%20to%20type%20numbers%20into%20a%20cell%20and%20it%20auto%20calculates%20the%20sum%2C%20like%20a%20calculator.%20I'm%20aware%20of%20the%20autosum%20feature%20for%20columns%20and%20rows%2C%20but%20that's%20not%20what%20this%20is.%20I%20want%20a%20specific%20cell%20to%20add%20the%20new%20numbers%20I'm%20typing%20in%20to%20the%20previous%20number.%20Does%20that%20make%20sense%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2862590%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm trying to find how I can use each cell as a calculator essentially. I'm making a financial spreadsheet and instead of using a calculator to add the totals from a website and then putting that new number in the cell, I would like to type numbers into a cell and it auto calculates the sum, like a calculator. I'm aware of the autosum feature for columns and rows, but that's not what this is. I want a specific cell to add the new numbers I'm typing in to the previous number. Does that make sense?

1 Reply

@katiet1570 

That's not a good idea. You wouldn't be able to audit what the sum is based on, and you wouldn't be able to correct mistakes.