Excel Sum Across Worksheets When Rows Are Lined Up Or Not – 2572

Microsoft Excel Tips and Tricks

Some call it a 3D reference or a spearing formula. If your Excel worksheets are all perfectly lined up, you can use this formula to sum across worksheets in Excel.But if your worksheets are not in the same sequence, then you can use TOCOL, SORT, UNIQUE, and SUMIFS to solve the problem.

Credit MrExcel.com