Multiple worksheets

Hello Victoria,
I hope you enjoyed your Excel training with us.

With regards to your question, I may need a bit more detail from you. It is possible to make calculations from different worksheets, and indeed different workbooks. The easiest way to do this is to use your mouse as the tool for selecting the cells in your calculations. If you try to type the formula, you may not get the syntax exactly as Excel requires it, which would result in an error or a botched calculation.

So as an example, if you want to add cell A1 on Sheet 1 and B2 on Sheet 2, start your calculation as:

=sum(

Then use your mouse to click on cell A1 on Sheet 1, then type a comma, then use your mouse again to click on cell B2 on Sheet 2. Then type a closed parenthesis, and hit enter.

This same premise will work on different types of formulas, and will also work with multiple workbooks.

I hope I have answered your question. If I have, please mark this question as resolved. If not, please feel free to reply and give me any specific information that might help paint a better picture of the issue you are having. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer