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
Post a Comment