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

[TABLE="width: 324"]
<tbody>[TR]
[TD]Rank
[/TD]
[TD]Name
[/TD]
[TD]Might
[/TD]
[TD]Ave Score
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Pocay
[/TD]
[TD]311,432
[/TD]
[TD]3,481
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]MagnumTheViking
[/TD]
[TD]277,644
[/TD]
[TD]3,366
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]armymom128
[/TD]
[TD]276,803
[/TD]
[TD]3,355
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]alphacolt
[/TD]
[TD]276,605
[/TD]
[TD]3,356
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]jholer
[/TD]
[TD]275,756
[/TD]
[TD]3,345
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]inKREDible
[/TD]
[TD]275,443
[/TD]
[TD]3,353
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]34Juice123
[/TD]
[TD]273,921
[/TD]
[TD]3,351
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.