Simple Excel Tutorial–How To Sum Multiple Excel Tables Across Sheet

Date:2021-6-16 Author:Sandra

Let’s say you are a class teacher, and the math teacher and chemistry teacher have each given you a report card. You need to sum up the class’s grades in math and chemistry. How to do this quickly?

Simple Excel Tutorial--How To Sum Multiple Excel Tables Across Sheet
Simple Excel Tutorial--How To Sum Multiple Excel Tables Across Sheet

Highlight cell C2 and go to the Formulas tab. Click on the arrow of Math & Trig, then find SUM in the list.

Simple Excel Tutorial--How To Sum Multiple Excel Tables Across Sheet

Click on cell B2 in Sheet 1 to enter B2 in Number 1, and do the same for the cell B2 in Sheet 2 for Number 2, then hit OK.

Simple Excel Tutorial--How To Sum Multiple Excel Tables Across Sheet
Simple Excel Tutorial--How To Sum Multiple Excel Tables Across Sheet

You’ve got the total grades of Math and Chemistry in this way. Is it simple and efficient?

Simple Excel Tutorial--How To Sum Multiple Excel Tables Across Sheet
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *