I feel like I should get this one, but am falling short on finding my error.
I have data, listed below. My averageif formula is: =AVERAGEIF('Historical Scores'!A:A,$B3,'Historical Scores'!E:I). My understanding is: 'Historical Scores'!A:A is pulling Names, $B3 is matching the pulled name...