adding off of multiple sheets

[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

[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]...
>
> 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
>
>
> --
> bustanutti21
> ------------------------------------------------------------------------
> bustanutti21's Profile:
http://www.excelforum.com/member.php...o&userid=25542
> View this thread: http://www.excelforum.com/showthread...hreadid=495834
>