Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display sums from multiple worksheets on one worksheet
I am working on a budget plan. So I have multiple totals from various months
that I would like to display on one "totals" page so i can track each month. for example, I have the totals from bikes, cars, and transit on the november worksheet. on the "totals" page I have the totals from bikes, cars, and transit for every month of the year. i kept the names consistent from each page hoping that would simplify things. so far it has not. is there a way to display the totals from each month on the "totals" without having to type a similar formula in each succeeding row? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
display sums from multiple worksheets on one worksheet
If you setup the columns and page tabs consistently you could use an
"indirect" command that would take the month from the column and then your reference. It can be a bit tricky to learn but great once you know it. The indirrect command lets you build a reference. So by having the tabs and the column name the same, you can reference the column name in the indirect reference to the tab, and then you just have to add the cell reference. Another option is to name the cells and then just refer to them. If you are just looking for a year to date and the items are stacked, you can do a 3d sum. Just put a =sum( and then choose the set of tabs you want and the one cell, it will pull them all. "rumski20" wrote: I am working on a budget plan. So I have multiple totals from various months that I would like to display on one "totals" page so i can track each month. for example, I have the totals from bikes, cars, and transit on the november worksheet. on the "totals" page I have the totals from bikes, cars, and transit for every month of the year. i kept the names consistent from each page hoping that would simplify things. so far it has not. is there a way to display the totals from each month on the "totals" without having to type a similar formula in each succeeding row? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Multiple Worksheets | Excel Worksheet Functions | |||
Display Multiple Worksheets | Excel Worksheet Functions | |||
Multiple Line Display Of Worksheets | Excel Worksheet Functions | |||
display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
Display data from multiple worksheets' cells in one worksheet | Excel Worksheet Functions |