Named ranges, 3-D ranges, and/or arrays?

K

K. Georgiadis

Advice is requested:
I will have as many as 10 identical worksheets, sales
totals of which will need to be aggregated.
For example, there will be an identical row ("Total
Regional Sales", in 10 different sheets, containing sales
BY YEAR 2004 thru 2009.
What would be the most efficient and error-free way to
aggregate these sales by year in an 11th worksheet?
 

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

Similar Threads

Date Format and Sumproduct 9
SUM and IF using two date ranges 2
Redundant Named Ranges Linking to Other Files 1
Naming ranges? 2
Formulas in arrays and named ranges 2
Sumproduct using named ranges and multiple criteria 5
creating set of named ranges 2
Creating a profit and loss from MSQuery Data 2

Top