Averages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimenda - 21 Dec 2005 23:01 GMT

I have 55 worksheets in a file, they are all formatted the same way. Each
sheet has totals entered for individuals by catagory and by date. I would
like to create a new worksheet that I can display totals and averages from
the data on the other 55 sheets. Is there a way I can achieve this short of
typing out all the locations for each sum or average?

Signature

Thank You & God Bless,

Jimenda

Reply to this Message

bpeltzer - 21 Dec 2005 23:24 GMT

If you're consistently pulling data from the same place on each sheet, you
could use indirect and address. For example, if you want to pull data from
Sheet2 cell E1, you could put 'Sheet2' in cell A2, then the formula
=INDIRECT(ADDRESS(1,5,,,A2)) in cell B2. Fill column A with additional sheet
names and autofill column B with the formula. So you'd have to enter each
sheet name once, but then you could reference it in multiple such INDIRECT
formulas.
HTH. --Bruce

> I have 55 worksheets in a file, they are all formatted the same way. Each
> sheet has totals entered for individuals by catagory and by date. I would
> like to create a new worksheet that I can display totals and averages from
> the data on the other 55 sheets. Is there a way I can achieve this short of
> typing out all the locations for each sum or average?

Reply to this Message