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)
.
Thank you very much 🙂
Merci pour le savoir-faire partagé
Nice job. Thank you
I will try this