Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
close workbook without closing excel and stop recursive function | Excel Discussion (Misc queries) | |||
make it possible to get to the function reference for excel when | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
In Excel, can a function yield a drop-down list? | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |