Microsoft Excel Tutorial: Sum across worksheets when rows do not line up?

Today’s question from Rebaz on podcast 1984 – Excel Sum Across Worksheets: “if we have different cell in different sheet, how can I Sum?”

Download the workbook from today: https://www.mrexcel.com/youtube/UO11Ase1_Ys/

This video shows you an easy way to build a 3-D reference in Excel, also known as a spearing formula. Excel functions include SUM, XLOOKUP, FILTER, SUMIFS, TEXTJOIN, TEXTSPLIT, SUMPRODUCT, Helper Arrays, LET, Python in Excel, and VSTACK.

Table of Contents
(0:00) Problem: Adding Across Sheets that are not lined up
(0:43) How to build a 3-D Reference
(1:19) Does XLOOKUP work with 3-D?
(1:50) Does FILTER work with 3-D?
(2:09) Does SUMIFS work with 3-D?
(2:38) TEXTJOIN works with 3-D References
(3:23) TEXTSPLIT of TEXTJOIN
(3:48) Building out TEXTJOIN solution
(5:36) Using Python in Excel Fails with a Formula
(6:01) VSTACK works with 3-D
(6:45) Could use Power Query
(7:04) How would you do this?
(7:09) Is there a list of Excel functions that work with 3-D?
(7:36) Wrap-up / Nancy Faust
(7:45) Please subscribe