Thread: TOTALS
View Single Post
  #2   Report Post  
Shay
 
Posts: n/a
Default

gowvugo wrote:
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.