1, open a workbook, such as calculating the contents of the same position in the second and third worksheets, you can enter in the first worksheet:

=sum('* '！ a 1)？ You can directly calculate the sum of Sheet2:Sheet3.

2. Note that the formula will automatically become: =SUM(Sheet2:Sheet3! A 1)

2. If the cell locations are different, we can click Join manually.