Home  >  Article  >  Topics  >  How to automatically sum columns in excel

How to automatically sum columns in excel

藏色散人
藏色散人Original
2020-02-13 09:49:354240browse

How to automatically sum columns in excel

How to automatically sum horizontal columns in excel

Excel allows horizontal summation, if automatic summation does not work , you can manually write the summation formula yourself to implement the summation.

The method steps are as follows:

1. Open the EXCEL table that needs to be operated, and enter "=SUM(" in the function edit box above the cells that need to be summed.

How to automatically sum columns in excel

2. Complete the editing of the summation formula by manually selecting the summation cell and adding ")" at the end of the formula.

How to automatically sum columns in excel

#3. After entering the formula, click the "Enter" key on the keyboard to manually complete the horizontal sum.

How to automatically sum columns in excel

4. Return to the EXCEL table and fill in the cell formula below by pulling down. You can find that the horizontal manual sum has been successfully completed in EXCEL.

How to automatically sum columns in excel

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn