B
Brian
I need to count individuals' scores based on 2 criteria: the Team each
individual belongs to (Team 1, 2, 3 or 4) and the individual's score itself.
So, in a database sorted alphabetically by name (not by Team), I'd want to
know (for example) how many individuals scored 30-35 points in Team 1.
Is there a worksheet function (or combination of functions) that can
accomplish this?
This is an example of how my database is set up. The headers TEAM, NAME &
SCORE represent columns A, B & C.
TEAM NAME SCORE
1 ADDISON 23
2 ANTENOR 19
1 BASZLER 26
4 ABRAHAM 25
3 ANSON 36
3 ARIAS 12
2 BADGLEY 18
4 ADAMS 16
2 ALLEN 16
1 BELL 9
3 BENAVIDES 24
1 AKRE 17
1 BARISON 39
4 BARNER 36
3 BARTON 23
Thanks,
Brian
individual belongs to (Team 1, 2, 3 or 4) and the individual's score itself.
So, in a database sorted alphabetically by name (not by Team), I'd want to
know (for example) how many individuals scored 30-35 points in Team 1.
Is there a worksheet function (or combination of functions) that can
accomplish this?
This is an example of how my database is set up. The headers TEAM, NAME &
SCORE represent columns A, B & C.
TEAM NAME SCORE
1 ADDISON 23
2 ANTENOR 19
1 BASZLER 26
4 ABRAHAM 25
3 ANSON 36
3 ARIAS 12
2 BADGLEY 18
4 ADAMS 16
2 ALLEN 16
1 BELL 9
3 BENAVIDES 24
1 AKRE 17
1 BARISON 39
4 BARNER 36
3 BARTON 23
Thanks,
Brian