| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |
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.
Welcome to episode 2572 of our Excel tutorial series! In this video, we will be discussing how to sum data across multiple worksheets, even if the rows are not lined up. This can be a tricky task, but with the right techniques, it can be easily accomplished.
The first example we will be looking at assumes that all of the sheets are exactly lined up. This means that the data is in the same rows on each sheet. To begin, go to the /”Total/” worksheet and start where you want the first total to be. Type in /”equal/
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
