Excel - One Workbook with 13 Worksheets

[joemyst]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I created a single worksheet with a number of cells that I input values, then I duplicated it 11 times (one worksheet for each month of a year). Now I created another worksheet (again in the same workbook) and I want to create a yearly total from the same cells across previous 12 worksheets. I know it can be done (did it a number of years ago) but I can't fine the formula content necessary to perform this task.

Can anyone help?
Thanks

 

[CyberTaz]

One Option, assuming Sheet1-Sheet12 are the monthlies & Sheet13 is the one
you want the totals on & that there is a value in cell J25 on each of the
first 12 sheets;

In the cell on Sheet13 where you want the total enter the formula:

=Sum(Sheet1:Sheet12!J25)

 

[joemyst]

One Option, assuming Sheet1-Sheet12 are the monthlies & Sheet13 is the one

> you want the totals on & that there is a value in cell J25 on each of the
> first 12 sheets;
>
> In the cell on Sheet13 where you want the total enter the formula:
>
> =Sum(Sheet1:Sheet12!J25)
>
> --
> HTH |:>)
> Bob Jones
> [MVP] Office:Mac
>
> wrote in message
> news:[email protected]...
>
> Bob - - Thanks!!

It's has to be at least 5 years ago I did this - - I spent a couple of hours this afternoon researching on line help, and various manuals - - no one really had the answer. Now that I see it - - I got it - - thanks so much!

Joe