View Single Post
  #3   Report Post  
quailhunter
 
Posts: n/a
Default Calculating average scores from multiple sheets' information


From the D4 cell on the 'Averages' sheet, how would I get the average of
all scores in column D4 across all 3 sheets (week03-week01) for the
individual named in the Averages sheet (A4)? All sheets are sorted by
name, but each sheet may contain not all names on the Averages sheet.


--
quailhunter
------------------------------------------------------------------------
quailhunter's Profile: http://www.excelforum.com/member.php...o&userid=27739
View this thread: http://www.excelforum.com/showthread...hreadid=476554