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.
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.
Enter "=sum", which is the summation formula.
Press "Ctrl" and click on the cell, then press Enter to display the total.
Enter the "=" value plus the value, and press Enter to also display the sum.
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!