Average If, Data on another Tab, Averaging Rows

[SteelerMike]

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, 'Historical Scores'!E:I should be averaging the 5 rows: E, F, G, H, & I. But, the average returned is the data listed in cell 'Historical Scores'!E. I can't seem to get Excel to pull the full range E:I. I have tried to add the column, i.e. =AVERAGEIF('Historical Scores'!A2:A1000,$B3,'Historical Scores'!E2:I1000), doesn't change the result.

Any ideas appreciated.

Thanks,
Mike

Rank	Name	Might	Ave Score
1	Pocay	311,432	3,481
2	MagnumTheViking	277,644	3,366
3	armymom128	276,803	3,355
4	alphacolt	276,605	3,356
5	jholer	275,756	3,345
6	inKREDible	275,443	3,353
7	34Juice123	273,921	3,351

<tbody>
</tbody>

 

[Aladin Akyurek]

Control+shift+enter, not just enter, one of:

=AVERAGE(IF('Historical Scores'!$A$:$A$4000=$B3,'Historical Scores'!$E$2:$I$4000))

=AVERAGE(IF('Historical Scores'!$A$:$A$4000=$B3,IF(ISNUMBER('Historical Scores'!$E$2:$I$4000),'Historical Scores'!$E$2:$I$4000)))

 

[SteelerMike]

Control+shift+enter, not just enter, one of:

=AVERAGE(IF('Historical Scores'!$A$2:$A$4000=$B3,'Historical Scores'!$E$2:$I$4000))

=AVERAGE(IF('Historical Scores'!$A$2:$A$4000=$B3,IF(ISNUMBER('Historical Scores'!$E$2:$I$4000),'Historical Scores'!$E$2:$I$4000)))

Used the top one...works perfectly!

Thank you very much,
Mike

 

[Aladin Akyurek]

Used the top one...works perfectly!

Thank you very much,
Mike

You are welcome. Thanks for the update.