Sunday, April 28, 2013

yogi_Compute Count Of Win Loss Tie And Present Results In A Single String

                                          Google Spreadsheet   Post  #1160
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 28, 2013
user Joe Stennet : (!mydiscussions/docs/YytJcX_iPjs)
I am trying to edit a spreadsheet used by my daughter's softball league to count the number of wins/losses/ties in a range and report it (ex: 8/5/1).
I tried =COUNTIF(G4:G17, "Win")&"/"COUNTIF(G4:G17, "Loss")&"/"COUNTIF(G4:G17, "Tie"), but it doesn't work. What am I missing?
Thank you... Hopefully I did it correctly...

here we go