98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · High Priority · Version 2010
Tue 19 Nov 2013, 11:07Delegate Catherine said...
Catherine has attended:
Excel Intermediate course
Excel
I have a 5 page worksheet and I need to link them together so that the 1st worksheet adds up the data when I input it into the other 4 worksheets, its a P&L document so the forumalas are in the latter 4 worksheets but I cannot get them all to add up in the first worksheet no matter what I do. I have been able to link worksheet 1 and 2 but not 3 - 5.
Can anyone help? Thanks,
Wed 20 Nov 2013, 14:47Trainer Cindy said...
RE: Excel
Hello Catherine,
Thank you for your question regarding linking worksheets.
Lets say the five worksheets you refer to are called worksheet1, worksheet2, worksheet3, worksheet4 and worksheet5. And you want cell A1 of worksheet1 to contain the total of the values in cell B1 of the other 4 worksheets.
In worksheet1 click into cell A1 (or wherever you want the answer to go) and type = then click worksheet2, cell B1, then type +. Then click worksheet3, cell B1, then type +. Then click worksheet4, cell B1, then type +. Then click worksheet5, cell B1, then press enter.
If done correctly you will get an answer and the formula should look something like this:
= worksheet2!B5 + worksheet3!B5 + worksheet4!B5 + worksheet5!B5
(No spaces are needed within the formula)
Hope this helps.
Kind regards
Cindy
Microsoft Office Trainer
Wed 27 Nov 2013: Automatically marked as resolved.
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:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
