How would i make a table to keep track of win/loss totals?
How would i make a table to keep track of win/loss totals?
Chris
Give us a little more than that. What do you want this table to look
like? What data do you want in the table? What do you want the table to do
for you? HTH Otto
"Chris1" <Chris1@discussions.microsoft.com> wrote in message
news:34E1BDD4-B925-4C10-BEB7-348887E5D3BA@microsoft.com...
> How would i make a table to keep track of win/loss totals?
> 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)"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks