Forum Discussion
Calculator
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?
4 Replies
Hellokatiet1570,
Excel cannot make a single cell keep adding new numbers you type into it. A cell can only hold a value or a formula, not both.
The correct approach is to enter each number in separate cells and use a SUM formula.
Example:
A1: 10
A2: 20
A3: 30
B1: =SUM(A:A)If you want a running total in one cell, you can enable iterative calculation and use:
A1: =A1+B1Then enter new numbers in B1 and A1 will accumulate the total, but this method is not recommended for financial spreadsheets.
Best practice is to store values in rows or columns and use SUM.
I get what you’re trying to do, but Excel doesn’t really work like a running calculator inside a single cell. Once you type a value, it replaces the previous one, so it won’t “remember” and keep adding automatically.
A better and safer approach is:
- Use separate cells to enter each number
- Then use a formula like =SUM(A1:A10) to calculate the total
This way, you can always see where your numbers came from and fix mistakes easily (which is important, like Hans mentioned).
If you just want to quickly verify calculations or understand how weighted totals work (like with grades or similar data), I tested this simple tool: https://gwacal.com/
It helped me double-check results without messing up my spreadsheet.
For Excel specifically, sticking with formulas is still the most reliable method.
A https://gwa-calculator.net/ is a specialized tool used to compute the General Weighted Average (GWA), which helps assess a student's academic performance by calculating the weighted average of grades across various subjects. By considering both the grades and the number of units per course, it provides an efficient and accurate way to track academic progress. This tool is valuable for students, educators, and institutions in evaluating overall academic standing.
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.
