How to calculate the sum in excel

Calculate a sum in Excel: Select the range of cells you want to add. Go to the Formulas tab and click on the Sum icon (Σ). Excel will automatically enter the formula and calculate the sum, which appears in the selected cells.

How to Calculate a Sum in Excel

Calculating a sum in Excel is a common operation. This article will give you step-by-step instructions on how to do this.

Step 1: Select the range of cells to be summed

• Drag with the mouse to select the cells to be added.
• Alternatively, use the keyboard shortcut "Ctrl A" to select the entire worksheet.

Step 2: Click the Sum icon

• Go to the Formulas tab.
• In the "Function Library" group, click the "Sum" icon (Σ).

Step 3: Use the formula

• Excel will automatically enter the formula "SUM (cell range)" into the formula bar.
• For example, if you want to sum the cell range A1:A10, the formula would be "=SUM(A1:A10)".

Step 4: Press Enter

• Press the Enter key and Excel will calculate and display the sum of the cell range.
• The sum will be displayed in the selected cell.

Other methods

Automatic summation

• After selecting the cells to be summed, click Click the Home tab and click the AutoSum button.
• Excel will automatically create the sum formula.

SUBTOTAL Function

• The SUBTOTAL function can be used to calculate the sum including or excluding hidden cells.
• The syntax is "=SUBTOTAL(function code, cell range)".
• For example, to calculate the sum of all visible values ​​in the cell range A1:A10, you can use the formula "=SUBTOTAL(109, A1:A10)".

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