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     www.energyefficientbuild.com.    Apr 28, 2013
user Joe Stennet : (https://productforums.google.com/forum/#!mydiscussions/docs/YytJcX_iPjs)
Countif?
Hi,
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?
Thanks!
-Joe
---
Thank you... Hopefully I did it correctly...

Joe
-----------------------------------------------------------------------------------------------------------------
here we go