Reference a list to perform a function in Excel
 

Excel 2003
I have several similar list of products with the number of each product sold
on several sheets. The first sheet would be a total for everyone and
subsequent sheets are individual teams. I would like show what percentage
each team is contributing to the total number. The trouble being, each list
is continually changing and the products dont fall in the same rows for each
sheet. I am looking for something similar to Vlookup, but instead of entering
a column index with a result, I need to be able to enter a function. Thanks.

Reference a list to perform a function in Excel
 

On your summary sheet, can you just do a sum function that refers to an
arbitrarilly large range on each sheet to be summed (divide it by 2 if you
also have a sum in the column on each sheet)?

For example, on the Summary sheet, have the function
=sum ( SUM( Sheet1!B1:B100 )
+ SUM( Sheet2!B1:B100 )
+ SUM( Sheet3!B1:B100 ) ) /2

Another approach is to put your sheet sums at the top of each sheet. This
was they're always in the same location, which is easy to summarize.



"matt ashley" wrote:

Excel 2003
I have several similar list of products with the number of each product sold
on several sheets. The first sheet would be a total for everyone and
subsequent sheets are individual teams. I would like show what percentage
each team is contributing to the total number. The trouble being, each list
is continually changing and the products dont fall in the same rows for each
sheet. I am looking for something similar to Vlookup, but instead of entering
a column index with a result, I need to be able to enter a function. Thanks.