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

if you do not get a reply from anyone and you would like more help, email me at


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