google spreadsheet - Score calculation for two different teams -


how go counting scores between c1 , c8 , entering values a2 , b2?

a1 = blue  b1 = red   a2 = team blue score  b2 = team red score 

between c1 c8 = winning team & score (note: c1 = $a$1&" 1.25" )

 c1 = blue 1.25  c2 = blue 2  c3 = red .5  c4 = draw  c5 = blue 1.5  c6 = blue 1.75  c7 = red 2  c8 = draw 

so should is:

a2 should =  6.5 b2 should =  2.5 

you can total score of blue team

=sum(arrayformula(if(left(c1:c, 4)="blue", value(regexreplace(c1:c, "[^0-9.]", "")), 0))) 

for red team, use left(c1:c, 3)="red" in formula.

the conversion text number happens in 2 steps: regexreplace removes characters except . , 0-9; value converts text number.


it better keep winning team , score in separate cells (team in column c, score in column d), simplify handling of data: you'd need =sumif(c1:c, "blue", d1:d).


Comments

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

Using django-mptt to get only the categories that have items -