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

adding

ResolvedVersion 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:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.