Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sum YTD totals based on monthly totals | Excel Discussion (Misc queries) | |||
Pivot Table Totals | New Users to Excel | |||
Totals For a Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot Table Grand Totals | Excel Worksheet Functions | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel |