View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Brian is offline
external usenet poster
 
Posts: 683
Default How do I count values w/ criteria located in more than one column

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