softgocommon.blogg.se

However, there are certain limitations to this AUTOSUM function, especially when we work with a large number of cells.

Since we have selected only the data range, it has given us the same formatting of the selected cells. As you can see above, it has inserted the SUM function in excel automatically upon pressing the shortcut key “ALT + =” hit the enter key to get the column total.Now press the shortcut key “ALT + =” to insert the AUTOSUM option.Select the cell, which is just below the last data cell.For example, in the above data, we have data till the 6 th row, so in the 7 th row, we need the total of the above column numbers. The temporary total can be just seen, but to make the totals permanently visible in a cell, we can use the autosum option. Example #2 – Get Auto Column Total in Excel In the previous case, we have selected the entire column, and the formatting of numbers was not there, but this time, since we have selected only the numbers range in the quick sum too, we can see the same formatting of the selected range. The total is the same, but the only difference is the formatting of numbers. Now instead of selecting the entire column, select the only data range and see the result.In order to get the total of this column “B,” just select the entire column or the data range from B2 to B6, first select the entire column and see the “Status Bar.”Īs you can see in the status bar, we have a quick sum showing as 26356.For example, look at the below data in excel.