How To Sum A Column In Excel

Just click on the letter of the column with the numbers you need to sum and look at the Excel status bar – this will tell you the total of the cells that have been selected.

This method doesn’t allow copying or displaying numeric digits, but does tend to offer the fastest and most efficient option.

To try this, click on the first empty cell under the column you want to sum – this avoids any extra, unwanted actions, such as wide range selection.

Next, click the Home tab, select the Editing Group, and click the button marked “AutoSum”.

When you are done entering the necessary information, Excel will apply the =SUM function automatically – you can press Enter to see the total of a certain column. Not only is this a fast method, but it also offers a chance to obtain and maintain the Sum result.

For this, click the cell in the table where you aspire to calculate the total of selected cells.

Select the range of cells with the number you want the total of, and hit Enter. You can also manually enter the range address – this can be useful for large ranges.

We start by filtering our table, by selecting any cell within the data, heading to the Data tab, and selecting the Filter icon.

Arrows will then appear in the headers of each column, and you can select the arrow beside the relevant header in order to narrow down the data.

Make sure that the Select All box is not checked, and then tick the values that you wish to filter according to, before clicking OK to see the results.

Next, select the range that you wish to add up, select AutoSum, and you will see the filtered cells.

Select the column you want to sum, then press Ctrl+T on your keyboard to format the range of cells into an Excel Table.

In the newly opened Design tab, navigate to the new Table section and tick the box to total rows.

Then click on the down arrow next to the selected cell, and choose Sum from the drop-down menu.