View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frank@D&D Office Plus Frank@D&D Office Plus is offline
external usenet poster
 
Posts: 1
Default Calculate points for and points against

Date - A Winner _ B Score C Mvp _ D Loser_ E Score_ F Mvp _G
10/11/2008 Team A 16 Sarah Team E 12 Taylor
10/11/2008 Team B 33 Kira Team F 14 Darian
10/11/2008 Team C 20 Wesley Team D 13 Halle
10/12/2008 Team B 35 Katelyn Team E 22 Lacey
10/12/2008 Team C 29 Allison Team G 15 Julie
10/12/2008 Team D 25 Rachel Team F 23 Olivia
10/16/2008 Team A 34 Amanda Team G 19 Mary


in the spreedsheet above, how can I calculate points for and points against,
I am going to want those totals on another sheet were I have the standings
( I calculated the standings wins, and loses using the count if)

Thanks
Frank