3D Sum Multiple Worksheet in Excel

You can sum same ranges in different worksheets by using the SUM function with 3d reference, a special syntax.

For example, we have three different sheets with same ranges.

the SUM function in cell B3 is:

=SUM(Jan!B3,Feb!B3,March!B3)

Result:

where,

“Jan!B3” – It is the reference of cell B3 in Sheet “Jan”,

“Feb!B3” – It is the reference of cell B3 in Sheet “Feb”,

“March!B3” – It is the reference of cell B3 in Sheet “March”.

For stepwise guide and to understand group worksheet feature, you may read ‘Group Worksheets in Excel‘.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved