Hi,
this can be acheived by using th COUNTIF formula:
=COUNTIF(Range,criteria)
You will need three formula for each column (one for each type):
=COUNTIF(column for team,"W") no of wins
=COUNTIF(column for team,"L") in cell below no of losses
=COUNTIF(column for team,"D") in cell below no of draws
You can use the concatenate formula to pull the result together with text if
you need to. ie =CONCATENATE(COUNTIF(B1:B10,"W"), " wins")
Hope this helps.
"Renan Germano" wrote:
Hello! I have a table with the results of each team?s recent games. In column A are the game dates, and in each other column is a team name (B1,C1,D1..). In B2,C2,D2 I put the result for that game, either W, D or L.
How can i make a formula that gives me the current streak for each team? It should give me, for example, 2 wins, 2 losses or 3 draws..
Tks
Submitted via EggHeadCafe - Software Developer Portal of Choice
Scriptless ASP Progress Indicator
http://www.eggheadcafe.com/tutorials...rogress-i.aspx
.