Rating Total

[bewise]

Hello,

I am new to the forum and i hope i can learn while i am here.

In my attached workbook.In sheet1 i have a layout of team members with ratings
what i would hope for is for someway to calculate each members rating and calculate it and then copy it to sheet2.
So if player1 is any where in col B and his rating in colF is greater than the player in colH and his rating in col L.
then he should get 1 point.
If it is not greater he loses a point.
This should happen for all players in this sheet until the end and their total copied to sheet2.see example.

Thanks

[benishiryo]

welcome to the forum. try this array formula:
=SUM(IF(Sheet1!$B$19:$B$200=B4,SIGN(Sheet1!$F$19:$F$200-Sheet1!$L$19:$L$197)))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[bewise]

Hello Benishiryo,

Thanks for your formula,i have tried it but it does'nt give me the correct answers.
in my example workbook example shows -4 for sheet2 D4 but when i place your formula and confirm with CTRL+SHIFT+ENTER.
i get 0 for the answer.
One other issue maybe it will not effect your formula but this dummy data when i try on original data the data in both sheets will be very changeable.
All data is automatically updated from another source.

The only thing i need to do is make sure sheet2 col D shows the results of each players rating against the opposition players rating and have the total as example in col D.

Thanks for your efforts.