I’m Lee and here to show you how to sum values in rows and columns in Excel.
There are multiple ways to add values in cells, but the method we will show you is the most straightforward and quickest.
Let’s get started.
How to Sum a Column in Excel Video
How to Sum a Column in Excel
Here’s a table with some data on sales of individual people for certain quarters.
We’ll use this table to demonstrate how the sum works.
Let’s say we want to total the sales for quarter 1.
We’ll click into cell C11 where we want to sum the sales.
We’ll find the ‘Home’ tab, section ‘Editing’, and select ‘AutoSum’.
Excel automatically marks the cells which you might want to add up.
Change the Sum Range
If you need to change the range of these cells, click into the top right corner of the selected group and change the range as needed.
In this case, we want to total all sales, so we’ll leave the marked area as it is from C3 up to C10, and press ‘Enter’.
And there it is – the sum of all sales for quarter 1!
How to Drag the Formula Across the Rest of the Columns
If you want Excel to calculate the sum for the rest of the quarters, you can simply click on the cell where the sum for Q1 has been calculated. Hover over the bottom right corner of the cell and drag the formula across the rest of the columns.
Second Way to Sum a Column in Excel
You can use the same way to add up values in rows, which represent sales of individual people for all quarters.
To add up the first row, we’ll click on the cell under the column ‘Total’ and then click on ‘AutoSum’.
Drag the Formula Across the Rest of the Columns
Press ‘Enter’ and copy the formula across the rows that need to be calculated by dragging the bottom left corner of the selected cell down the ‘Total’ column.
If you found this tutorial helpful, and if you want to learn Excel our complete guide section is the place to go that will help you use Excel like a boss!
Want to learn how functions work in excel? Then check out my excel functions page where you will learn many of the functions. Or looking for formulas? Well, we have you covered there too with our Excel Formulas page.