How to sum a column 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.

How to sum multiple rows in excel

Excel sum formula examples

How to sum a row in excel

Percentage formula in excel

Formula for sum in excel

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.

Advanced sum function in excel

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 write add formula in excel

how to insert add formula in excel for entire column