Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Averages
0 views
Skip to first unread message
Jimenda
Dec 21, 2005, 6:01:02 PM12/21/05
to
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?
--
Thank You & God Bless,
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?
--
Thank You & God Bless,
Jimenda
bpeltzer
Dec 21, 2005, 6:24:02 PM12/21/05
to
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
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
0 new messages