Tom’s Tutorials For Excel: Summing Ranges From Multiple Worksheets

Tom’s Tutorials For Excel: Summing Ranges From Multiple Worksheets

Here’s a visual representation of how to compose a formula on one worksheet that performs a mathematical operation from data on several other worksheets. The numbers in cells J5:J11 on the January, February, and March worksheets are all summed in the Total_Quarter1 worksheet.

On the Total_Quarter1 worksheet, the formula in cell B5 and copied down to cell B11 is
=SUM(January:March!B5).

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
4 comments on “Tom’s Tutorials For Excel: Summing Ranges From Multiple Worksheets
  1. Michel says:

    Thank you very much 🙂

  2. Cherif says:

    Merci pour le savoir-faire partagé

  3. Ismat says:

    Nice job. Thank you

  4. Tyrone says:

    I will try this

Leave a Reply

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

*