2. Open two tables, enter "Zhang San's" Chinese and math scores in Table A and "Zhang San's" physics and chemistry scores in Table B, as shown in the figure below:

3. Next, how to get the total score of "Zhang San" subjects.

Enter "=" first, and then select the Chinese and math scores in Table A, as shown in the figure:

4. After the Chinese and math scores are selected, enter "+"at the back, as shown in the figure:

5. Then open Table B and select the physics and chemistry scores, as shown in the figure:

6. Finally, directly press the "Enter" key on the keyboard, and EXCEL will immediately jump to Table A to calculate the total scores of "Zhang San" subjects, as shown in the figure below: