Current location - Education and Training Encyclopedia - Resume - Calculation method of summation formula
Calculation method of summation formula
The calculation method of the summation formula is sum (E 19: E37).

1, automatic summation formula is a simple function calculation method in EXCEL.

2. Open the Excel table in the computer.

3. After opening the Excel table, list and the required data.

4. If there are multiple data summation formulas, please enter the formula = sum (E 19: E37), where E 19 is the cell of the first data and E37 is the cell of the last data.

5. After entering the automatic summation formula, press Enter to determine the formula.

Introduction to excel:

Microsoft Office Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. The software's intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software.

1993, after the release of version 5.0 of Microsoft Office component, Excel began to become the overlord of spreadsheet software on the applicable operating platform.

On June 8, 20021year, the Ministry of Industry and Information Technology issued an App announcement on infringement of users' rights and interests (the fifth batch was 202 1, the total batch was 14), and Microsoft Excel was impressively listed.