Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using data from multiple worksheets in a formula
I have a workbook that will have 26 worksheets, the first worksheet will
serve as an index of data for a roster of students. The other worksheets will be divided by individual teachers. I need a formula that will search all the 25 worksheets for an individual student, then average the data for each student. I tried VLOOKUP but it will not give an average of let say 6 sets of data or scores from the 25 sheets. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula with multiple worksheets | Excel Worksheet Functions | |||
Formula help for multiple worksheets | Excel Discussion (Misc queries) | |||
Formula Referencing data on multiple worksheets | Excel Worksheet Functions | |||
How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
same data multiple worksheets | Excel Discussion (Misc queries) |