ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   team standings (https://www.excelbanter.com/excel-discussion-misc-queries/41673-team-standings.html)

Chris1

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

Otto Moehrbach

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" wrote in message
...
How would i make a table to keep track of win/loss totals?




Jay

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



All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com