Thread: team standings
View Single Post
  #3   Report Post  
Jay
 
Posts: n/a
Default

How would i make a table to keep track of win/loss totals?

One way is illustrated by the CSV file below.

--------------- cut here -----------------------
,"=""8/22""","=""8/29""","=""9/5""","=""9/12""",,W,L
Lions,W,W,,,,"=COUNTIF($B2:F2,G$1)","=COUNTIF($B2: G2,H$1)"
Tigers,L,W,,,,"=COUNTIF($B3:F3,G$1)","=COUNTIF($B3 :G3,H$1)"
Sharks,W,L,,,,"=COUNTIF($B4:F4,G$1)","=COUNTIF($B4 :G4,H$1)"
Pumas,L,L,,,,"=COUNTIF($B5:F5,G$1)","=COUNTIF($B5: G5,H$1)"