World Cup table

Hello,

Could anybody pleasse help how make a macro that counts goals for, goals againts and points different groups for the differnt teams in this years World Cup Soccer. I have created a excel document where I have entered all the games and also made the tables. But i don't know who to make a macro that will do the math based on the scores that will be entered. I've attached a copy of the excel file and if somebody could help me with this I would be grateful.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Try

GF: =SUMIF($A:$A,$H2,$D:$D)+SUMIF($C:$C,$H2,$F:$F)

GA: =SUMIF($A:$A,$H2,$F:$F)+SUMIF($C:$C,$H2,$D:$D)

Points: =SUM(IF((($A$1:$A$48=$H2)*($D$1:$D$48>$F$1:$F$48)+($C$1:$C$48=$H2)*($D$1:$D$48<$F$1:$F$48)),3,IF((($A$1:$A$48=$H2)+($C$1:$C$48=$H2))*($D$1:$D$48=$F$1:$F$48),1,0)))

Points is an ARRAY formula.