98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Multiple worksheets
Multiple worksheets
Resolved · Low Priority · Version Standard
Victoria has attended:
Excel Intermediate course
Excel Advanced course
Multiple worksheets
Is it possible to make calculations from multiple worksheets? I tried to do this manually, but it did not work.
RE: 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create Equations in Excel 2010Here's how to create basic mathematical |