TOTALS

[Guest]

I created a worksheet for each month. each colum of the workheet has a total.
How to i get those totals onto a separate workseet to show year to date?

 

[Shay]

I created a worksheet for each month. each colum of the workheet has a total.
How to i get those totals onto a separate workseet to show year to date?

to get the totals for the year:

create a new worksheet
select the cell you want the total to go into
hit =
click the worksheet tab with the first months total
click the total for that month
hit + on the numpad
click the worksheet tab for the second months total
click the total for that month
hit + on the numpad
etc. etc. for each of the 12 months
when finished hit Enter
you should now have the totals for each of the 12 months on the new
worksheet.