display sums from multiple worksheets on one worksheet

R

rumski20

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?
 
P

Paul

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top