General Help

Hey, with the world cup draw just gone, i was trying to make a spread sheet, one page tables, 2nd page results, and all u do is fill in the reults, and then it fills in the table automatic, i managed to do the formula's for, GF (simple, 3 cells added) GA (3 cells added again) and GD (= GF - GA) but i don't know how to do,

Games Won,
Games Drawn,
Games Lost,
Points,
and for Games played i did, a 1, or 0 next to each fixture, (so i just add a 1 when the game has been played - add all that team's together u get games played) [is there another way for that one??]

any help??

if you do not get a reply from anyone and you would like more help, email me at
excelmarksway@yahoo.com.au

Send the workbook and all explanatory notes.

http://www.geocities.com/excelmarksway



"M4dSk1llz" wrote:

>
> Hey, with the world cup draw just gone, i was trying to make a spread
> sheet, one page tables, 2nd page results, and all u do is fill in the
> reults, and then it fills in the table automatic, i managed to do the
> formula's for, GF (simple, 3 cells added) GA (3 cells added again) and
> GD (= GF - GA) but i don't know how to do,
>
> Games Won,
> Games Drawn,
> Games Lost,
> Points,
> and for Games played i did, a 1, or 0 next to each fixture, (so i just
> add a 1 when the game has been played - add all that team's together u
> get games played) [is there another way for that one??]
>
> any help??
>
>
> --
> M4dSk1llz
> ------------------------------------------------------------------------
> M4dSk1llz's Profile: http://www.excelforum.com/member.php...o&userid=29545
> View this thread: http://www.excelforum.com/showthread...hreadid=492457
>
>