When I add a name, below "Goals". Then the score for "Team A" or "Team B" must go up (B1 or B2).
The names of the team players are in Column D and E.
Does somebody knows a formula?
In the example below, the score should be
Team A 3
Team B 1
MacBook Pro 15″, OS X 10.11
You can try something like this:
The formula in C2 of Table 1-1, filled right and down:
=COUNTIF(Table 2::$A,A2)
The formula in B1 of Table 1:
=SUM('Table 1-1'::C)
The formula in B2 of Table 1:
=SUM('Table 1-1'::D)
If your region uses , as a decimal separator then replace , with ; in the formulas, e.g.:
=COUNTIF(Table 2::$A;A2)
You can of course hide columns C and D if you want.
SG
You can try something like this:
The formula in C2 of Table 1-1, filled right and down:
=COUNTIF(Table 2::$A,A2)
The formula in B1 of Table 1:
=SUM('Table 1-1'::C)
The formula in B2 of Table 1:
=SUM('Table 1-1'::D)
If your region uses , as a decimal separator then replace , with ; in the formulas, e.g.:
=COUNTIF(Table 2::$A;A2)
You can of course hide columns C and D if you want.
SG
Automatic Scoreboard
