Formula for sum in excel

Article SummaryX

The easiest way to find the sum of a column or row of numbers is to use Excel’s AutoSum feature.

Excel formulas

Subtraction formula in excel

Percentage formula in excel

How to add numbers in excel 1, 2, 3

How to sum a column in excel shortcut

Start by clicking the first empty cell below your data if summing a column, or the first empty cell next to your data if summing a row. On the Home tab, click the AutoSum button on the toolbar. This displays the SUM formula in the cell and highlights the cells to be added.

Press the Enter or Return key on your keyboard to see the sum of the selected cells.

Excel sum formula examples

You can also use the SUM function in your own formulas to add values. Let’s say you want to add the values of two cells in different columns, A2 and C5. First, click the cell where you’d like the sum to appear. Then, type an equals sign, followed by the word SUM.

Immediately after, type a left parenthesis, and then the address of the first cell, A2. Next to that, type a comma, followed by the address of the other cell in your equation, C5. Type a right parenthesis immediately after that to end the formula, and then press the Enter or Return key to see the results.

If y

how to sum multiple cells in excel

how to combine two cells in excel first and last name