How to Sum to End of a Column in Excel (8 Methods)

We will determine the sum of a column up to the bottom in Excel. We have taken a dataset that shows the store’s sales for the month of January.

Method 1 – Using Sum an Entire Column in Excel

Apply the SUM function throughout the entire column.

The SUM function adds all the numbers in a range of cells.

Steps:

Name cell E4 Total.

Go to cell E5 and enter the following formula:

=SUM(C:C)

Press ENTER to get the result.

We successfully get the sum of the entire Column C.

Method 2 – Using a Formula to Sum Multiple Columns

We have data in Columns C and D, and we want to get the sum of those columns.

Steps:

Go to cell F4 and enter the following formula:

=SUM(C:D)

Press ENTER.

We get the sum of those adjacent columns.

Method 3 – Using Sum Non-Contiguous Columns at Once

We have data in Columns C, D, and E. We will determine the sum of Columns C and E.

Steps:

Enter the following formula in cell G4:

=SUM(SUM(C:C),SUM(E:E))

Press ENTER to get the result.

We can apply another formula and will get the same result. The formula is:

=SUM(C:C, E:E)

One of the advantages of using the formula is that we don’t need to use the SUM function multiple times.

Method 4 – Using Sum Entire Column to End without a Header

Steps:

Enter the following formula in cell C5:

=SUM(C4:C1048576)

Press ENTER.

Method 5 – Using the Excel AutoSum Feature

Steps:

Select all the cells of column C.
Choose the AutoSum group from the Formulas tab.

Check out the dataset.

Here, we can see the sum is showing in the adjacent cell.

We apply another keyboard shortcut for AutoSum. Press Alt+ = and the AutoSum will apply.

Method 6 – Finding the Sum of a Column in the Status Bar

Steps:

Choose cells C4 to C11 of the dataset.

Look at the bottom of the sheet. We get the sum here. This sum value is for the selected cells. But we want to get the sum for the end of Column C.