Home  >  Article  >  Topics  >  How to do table automatic summing

How to do table automatic summing

王林
王林Original
2021-02-03 14:03:49237859browse

How to automatically sum the table: 1. Open the excel table and select the entire column of data to be automatically summed in the table; 2. Enter the summation formula [=sum] in the formula bar; 3. Press Press the ctrl key and press Enter.

How to do table automatic summing

The operating environment of this article: windows10 system, microsoft office excel 2019, thinkpad t480 computer.

Specific method:

Select the entire row and column directly in the table, and the default sum will appear below the table.

How to do table automatic summing

Enter "=sum", which is the summation formula.

How to do table automatic summing

Press "Ctrl" and click on the cell, then press Enter to display the total.

How to do table automatic summing

Enter the "=" value plus the value, and press Enter to also display the sum.

How to do table automatic summing

Learning video sharing: Introduction to programming

The above is the detailed content of How to do table automatic summing. 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