Countif more than one criteria

[manman]

I want to count the Database that I have like this:

A B
1 Date Team
2 1/1/2010 1
3 8/1/2010 2
4 9/1/2010 1
5 14/1/2010 1
6 18/1/2010 1
7 2/2/2010 2
8 22/1/2010 2
9 8/2/2010 2
10 19/2/2010 1

A
11 Jan-10
12 Team 1 (I want to count above data where Column A is greater than
Jan-10 (A11) and less than Feb-10 (A14) and Column B is "1")
13 Team 2 (Same as above but Column B is "2")
A
14 Feb-10
15 Team 1
16 Team 2

Since I only have Excel 2003, I cannot use "Countifs" function, can you show
me how I can make excel to count the criteria that I want?

 

[Bob Phillips]

Try

=SUMPRODUCT(--(A2:A10>A11),--(A2:A10<A14),--(B2:B10=1)

and so on.