Excel

Dear Veronika

Thank you for attending Access Introduction!! I hope you enjoyed the course and benefited from it.

Using different sheets to perform calculations is known as a 3D formula.

It is quite easy to perform. Please follow these steps:

I'm not sure what calculation you'd like to do so I'll give an example of my own. Let's say you want add cell D3 from sheet 1, sheet 2 and sheet 3.

1. Select the sheet you want to perform calculation on. In my example Sheet 4.


2. Click on the cell where you would like the calculation to be performed. In my example cell D3.

3. Type is =sum(

4. Select Sheet 1 and then keep Shift button pressed and then press Sheet 3. This will select all the three sheets.

5. Click on the D3 of the active sheet. Then close the bracket.

6. Press Enter.

You will see that the result that you get is the sum of D3 of all the sheets that you selected.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007