You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
