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)"
|