How to sum multiple cells in excel

How to sum multiple cells in excel: 1. Enter [=C2 D2] in the blank cell and press Enter to get the summed value; 2. In the blank cell Select Automatic Sum-Sum, then frame-select adjacent data and press Enter to get the result.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to sum multiple cells in excel:

1. Open the excel workbook as shown in the figure.

#2. Method 1 for summing adjacent cells: Enter =C2 D2 in the blank cell and press Enter to get the summed value. as the picture shows.

4. Method 2 for summing adjacent cells: Select Automatic Sum-Sum in a blank cell, then frame-select the adjacent data and press Enter. key to get the result. as the picture shows.

Related learning recommendations: excel tutorial

The above is the detailed content of How to sum multiple cells in excel. For more information, please follow other related articles on the PHP Chinese website!