adding off of multiple sheets

B

bustanutti21

Hi there.. I have a report that i need to create.. I have a file that
has 5 worksheets and i need to add a cell from sheet one to a cell in
sheet 5... I'm sure this is simple but i cant figure out how to add
from multiple worksheets

thanks
 
R

RagDyer

Let XL make the formula for you.

Click in the cell that is to display the total, and enter an equal sign,
=
then, click in the cell containing the first value,
Then hit the plus sign
+
Now, click on the Sheet5 tab, and click in the cell containing the second
value,
And then hit <Enter>.

You now have the syntax that you can duplicate for your other totals, or,
you can continue creating your formulas in the same manner that you did the
first one.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"bustanutti21" <[email protected]>
wrote in message
news:[email protected]...
 
Top