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

Calculate points for and points against
 

For Points For:
=SUMPRODUCT(($B$2:$B$20="Team A")*($C$2:$C$20))+SUMPRODUCT(($E$2:$E$20="Team
A")*($F$2:$F$20))

For Points Against:
=SUMPRODUCT(($B$2:$B$20="Team A")*($F$2:$F$20))+SUMPRODUCT(($E$2:$E$20="Team
A")*($C$2:$C$20))


--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"Frank@D&D Office Plus" wrote:

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