adding

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Adding

Adding

resolvedResolved · Medium Priority · Version 2003

Ana-rosa has attended:
Excel Introduction course

Adding

How add from two different sheets

RE: adding

Hi Ana-rosa, Thank you for the post and welcome to the forum, in answer to your question, you would set up a 3D formula, this is not as difficult as it sounds, follow these steps;
In the receiving worksheet in the cell you wish the result to appear, type = and your formula ie =SUM( then navigate to the sheet you wish to take information from and click on the cell you want, press the , (comma) and then navigate to the next location, click on the cell, continue in this vein if necessary, when you have exhausted the number of cells you wish to SUM close the brackets ()) and press ENTER.
I hope that has helped, best regards Pete


 

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.08 secs.