Step-by-Step Guide: Mastering the Art of Summing Up Entire Columns in MS Excel

Quick Links

• Ways to Sum a Column’s Values in Excel
• View Your Column’s Sum in Excel’s Status Bar
• Sum Your Column’s Values Using Excel’s AutoSum Feature
• Sum a Column’s Values With Excel’s SUM Function

Microsoft Excel offers multiple ways to sum the values of a specific column . You can use the status bar, AutoSum, and the SUM function to add up the values in your column. Here’s how to use them.

Related: How to Add Numbers in Microsoft Excel

Ways to Sum a Column’s Values in Excel

One way to sum a column is to use Excel’s status bar . If you only want to see the sum and you don’t want to display it anywhere in your spreadsheet, use this method.

The second method is to use AutoSum, an Excel feature that automatically adds the SUM function with its required arguments to your selected cell.

Lastly, you can use the popular SUM function to sum an entire column or specific rows or ranges in it.

View Your Column’s Sum in Excel’s Status Bar

To only view the sum of your column, then first, launch your spreadsheet with Microsoft Excel.

In your spreadsheet, select the cells in your column for which you want to see the sum. To select your entire column, then at the top of your column, click the column letter.

In Excel’s bottom bar, next to “Sum,” you’ll see the calculated sum of your selected cells.

EmEditor is a fast, lightweight, yet extensible, easy-to-use text editor, code editor, CSV editor, and large file viewer for Windows. Both native 64-bit and 32-bit builds are available, and moreover, the 64-bit includes separate builds for SSE2 (128-bit), AVX-2 (256-bit), and AVX-512 (512-bit) instruction sets. New versions support AI-assisted writing.

Additionally, the status bar displays the count as well as the average of your chosen cells.

Related: How to Copy Values From the Status Bar in Microsoft Excel

VSDC Pro Video Editor is a light professional non-linear video editing suite for creating a movie of any complexity. It supports the most popular video/audio formats and codecs, including 4K, HD and GoPro videos. Preconfigured profiles make the creation of videos for various multimedia and mobile devices absolutely hassle-free.

• Import from any devices and cams, including GoPro and drones. All formats supported. Сurrently the only free video editor that allows users to export in a new H265/HEVC codec, something essential for those working with 4K and HD.
• Everything for hassle-free basic editing: cut, crop and merge files, add titles and favorite music
• Visual effects, advanced color correction and trendy Instagram-like filters
• All multimedia processing done from one app: video editing capabilities reinforced by a video converter, a screen capture, a video capture, a disc burner and a YouTube uploader
• Non-linear editing: edit several files with simultaneously
• Easy export to social networks: special profiles for YouTube, Facebook, Vimeo, Twitter and Instagram
• High quality export – no conversion quality loss, double export speed even of HD files due to hardware acceleration
• Stabilization tool will turn shaky or jittery footage into a more stable video automatically.
• Essential toolset for professional video editing: blending modes, Mask tool, advanced multiple-color Chroma Key

Sum Your Column’s Values Using Excel’s AutoSum Feature

To get the sum of the contiguous cells of your column, utilize Excel’s built-in AutoSum feature. With this method, you select the cell at the bottom of your column values and access the feature, and then it fills in the SUM function with the necessary arguments for you.

To use it, first, open your spreadsheet and click the cell in which you want to get the result. The feature will add up all the values above the selected cell.

Epubor Audible Converter for Win： Download and convert Audible AAXC/AA/AAX to MP3 with 100% original quality preserved.

While your cell is selected, in Excel’s “Home” tab at the top, select the “AutoSum” option

In your chosen cell, AutoSum has filled the SUM function with your data range. If this looks good, press Enter.

You’ll see the result of the SUM function in your cell.

And you’re all set.

Sum a Column’s Values With Excel’s SUM Function

Excel’s SUM function is widely used to add up the values in your spreadsheets. You can use this function to add up specific cells, data ranges, and even an entire column. This is the same thing that AutoSum does, but we’re going to show you how to type it in manually and modify it to narrow the selection.

To do that, first, launch your spreadsheet with Microsoft Excel and click the cell where you want to see the result.

In your selected cell, type the following function and press Enter. In this function, replace

    `C2:C22`

with the range where your data is located. If you enter the function as is, it’ll add up all the numbers from the

    `C2`

until the

    `C11`

rows.

=SUM(C2:C11)

To count values from specific column cells, add your cells in the SUM function separated by a comma as follows:

=SUM(C2,C5,C8)

To add a range and specific cells, use the SUM function as follows:

=SUM(C2:C5,C8,C10)

To sum an entire column, use the column letter in the SUM function’s argument as follows. You’ll want to use this function in a cell that’s in a different column.

=SUM(C:C)

You’ll see all the rows added up in your selected cell.

As you can see, adding up numbers from your columns in Microsoft Excel is as easy as using a built-in feature or manually entering the SUM function. We hope our guide helps you out.

Do you want to calculate the sum of squares in Excel ? If so, there’s a way to do that.

Related: How to Calculate the Sum of Squares in Excel