Need help creating an excel sheet for historical finishes in my fantasy football league

[dogstronauts]

Hello there, I am hoping this place can help me with what I am trying to do.

I have the top 3 finishes since 2004 for our fantasy football league. I want to create a basic function where 1st place gets 3 points, 2nd place gets 2 points and 3rd place gets 1 point.

I want to see the total amount of points for each player in our league. I have Google Docs and Microsoft Excel. The attached screen shot is of Google Docs, but I can do it on excel if need be.

Anyone have a tutorial I can use to get this done?

 

[mrshl9898]

In G2 =(COUNTIF(B:B,F2)*3)+(COUNTIF(C:C,F2)*2)+COUNTIF(D:D,F2)