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

nnnn

Microsoft Excel Tips and Tricks

nnSome 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.nnnn

Credit MrExcel.com

n