3D sum functionality in Excel is quite awesome feature which simplifies the lengthy process. If used wisely, you can ease your task in spreadsheet. In order to understand the use of 3D Sum, first you need to look at the formula below:
Actually, there are several wordsheet on different subjects. Each worksheet carries marks obtained by various student. So, we have to make a ssummary exam result or report card so that it could be issued to the students.
How to Prepare Exam Result in Excel 3D Sum Multiple Worksheets
Alternatively, we can apply SUM formula and choose E7 from each sheet to find out total marks obtained by John. You have to do this for every student. But SUM 3D has made this task so easy that you do not need to refer each worksheet individually. Just tell the Excel the 1st and the last sheet to complete the task and that's it.