Brian you need to use the following:

=SUMPRODUCT(--(A2:A16=1),--(C2:C16=30),--(C2:C16<=35))

The criteria can be put is cells so you can say A2:A16=E10...

The other way to do it is to use auto filter with custom filters and the
subtotal

=SUBTOTAL(2,C2:C16) at the bottom with one line free.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Brian" wrote:

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