I'd like to create a sheet that shows average scores for each individual
with scores in other worksheets. This 'averages' sheet is in sorted name
sequence, as are all of the score sheets.
1. Using the name of the individual on the 'Averages' sheet, I'd like
to find all scores in one specific column across all other scoring
sheets.
2. Also, if a sheet contains no score (blank or zero) for that
individual, then don't factor that into the average. Using just this
AVERAGE function below, returns an invalid average if an individual has
only 2 out of 3 scores:
=AVERAGE(Week03:D4Week01!D6)
I'm thinking I need to use a VLOOKUP function (SUM also???), but
haven't had much success getting past the invalid syntax message when
attempting to nest the function.
--
quailhunter
------------------------------------------------------------------------
quailhunter's Profile:
http://www.excelforum.com/member.php...o&userid=27739
View this thread:
http://www.excelforum.com/showthread...hreadid=476554