Forum Discussion
Adding numbers in a single cell without using formula bar
Hi, I'm pretty new to excel but I wanted to start tracking my spending and I figured excel was the easiest way to do it. I can use basic functions of excel that are useful for this, such as autosum ...
kaizo I don't think that is a good idea. It is better to use a separate cell for each number. If you format the range of cells with numbers as a table (Home tab, Format as table), any formula that points to a column in your new table will automatically work on all cells of that column. So you do not have to change your SUM formula when you add new numbers to the table. If you put your SUM above your tabel and use the View, Freeze panes option with the first cell in your table that contains a number, you can scroll down in your table and the sum will stay in view (see example).