Advanced count function
 

Lets say my data looks like this:
A B
5 Travis
4 Travis
3 Nick
2 Travis
1 Don
9 Mike

How do I make a count function that looks at that and the logic is:
If A is less than 4 and B equals Travis

And just to clearify that I understand if I get an answer, how would I do:
If A is greater than 2 and A less than 15 and B equals Travis

To verify, I want the number returned of how many results there are.
Thank you for looking, and for your help/time.

Advanced count function
 

Forgot to say, this is Excel 2003.

Advanced count function
 

Eric wrote...
Lets say my data looks like this:
A B
5 Travis
4 Travis
3 Nick
2 Travis
1 Don
9 Mike

How do I make a count function that looks at that and the logic
is: If A is less than 4 and B equals Travis

=SUMPRODUCT((A2:A7<4)*(B2:B7="Travis"))

And just to clearify that I understand if I get an answer, how
would I do: If A is greater than 2 and A less than 15 and B
equals Travis
....

=SUMPRODUCT((A2:A72)*(A2:A7<15)*(B2:B7="Travis"))

Advanced count function
 

First one:
=SUMPRODUCT(--(A2:A10<4),--(B2:B10="Travis"))

Second one:
=SUMPRODUCT(--(A2:A102),--(A2:A10<15),--(B2:B10="Travis"))

HTH,
Paul

"Eric" wrote in message
...
Lets say my data looks like this:
A B
5 Travis
4 Travis
3 Nick
2 Travis
1 Don
9 Mike

How do I make a count function that looks at that and the logic is:
If A is less than 4 and B equals Travis

And just to clearify that I understand if I get an answer, how would I do:
If A is greater than 2 and A less than 15 and B equals Travis

To verify, I want the number returned of how many results there are.
Thank you for looking, and for your help/time.