Addition with Excel formulas
Posted: Wed Jan 22, 2025 9:06 am
Another way to sum a column in Excel is with its formulas. The SUM() function allows you to sum a range of numbers. It is mostly used for arithmetic calculations in spreadsheets.
Let's see how to use this formula to add numbers.
Step #1: Identify your data range and select a cell
Locate the range of cells that have the numbers you want to sum. Click the cell where you want the total to appear.
For example, if your sum values are in cells A2 through A9, we'll choose A10 for the total.
Select the cell for the answer : How to sum a column in Excel
Select the cell for the answer
Step #2: Enter the SUM() formula
After you select the cell where you want the total to appear, type the formula. You can vp financial email list also select and drag the cursor across the range of numbers.
In this example, we will write, '=SUM(A2:A9)'.
Write the formula for the sum: How to sum a column in Excel
Write the formula for the sum
Step #3: Press enter
Once you have typed the formula, just press Enter.
Excel will calculate the total of all the numbers in cells A2 through A9 and display it in cell reference A11.
Press enter to get the answer : How to sum a column in Excel
Press enter to get the answer
Step #4: Add multiple intervals
If you want to add multiple intervals, you can separate them with commas.
For example, '=SUM(A2:A9,B2:B9)' This adds the numeric values in these cells and gives you the answer in the selected cell. It does not take into account text values, if any.
Let's see how to use this formula to add numbers.
Step #1: Identify your data range and select a cell
Locate the range of cells that have the numbers you want to sum. Click the cell where you want the total to appear.
For example, if your sum values are in cells A2 through A9, we'll choose A10 for the total.
Select the cell for the answer : How to sum a column in Excel
Select the cell for the answer
Step #2: Enter the SUM() formula
After you select the cell where you want the total to appear, type the formula. You can vp financial email list also select and drag the cursor across the range of numbers.
In this example, we will write, '=SUM(A2:A9)'.
Write the formula for the sum: How to sum a column in Excel
Write the formula for the sum
Step #3: Press enter
Once you have typed the formula, just press Enter.
Excel will calculate the total of all the numbers in cells A2 through A9 and display it in cell reference A11.
Press enter to get the answer : How to sum a column in Excel
Press enter to get the answer
Step #4: Add multiple intervals
If you want to add multiple intervals, you can separate them with commas.
For example, '=SUM(A2:A9,B2:B9)' This adds the numeric values in these cells and gives you the answer in the selected cell. It does not take into account text values, if any.