| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding the average across multiple sheets
I'm trying to find the average for a person with scores in column 4 on 3 separate sheets. The following function returns #VALUE.. What am I doing wrong? Because the person may be in a different row on each sheet, I'm thinking I need to use the VLOOKUP function.... Help!!! Also, as an aside, the person may have a zero on one sheet that would affect the average score... =AVERAGE(VLOOKUP(A4,Week03:Week01!A$4:G$30,4,0)) -- quailhunter ------------------------------------------------------------------------ quailhunter's Profile: http://www.excelforum.com/member.php...o&userid=27739 View this thread: http://www.excelforum.com/showthread...hreadid=477377 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
| selecting multiple sheets | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Weighted Avg - using values from multiple sheets | Excel Worksheet Functions | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Threaded Mode
