Counting Formula

[Guest]

I am working on a work book that has 2 sheets. The first sheet is a summary
page, and the 2nd is a data list. The data list looks like this:

NAME AGE
Dave 5
Dave 96
Dave 41
James 25
James 102
Kate 61
Kate 17
Kate 19
Kate 2

There are about 2000 rows of different names and ages. The summary page
looks like this.

Name >25 >50 >100 > 150

I have used the countIf formula to count the amount of times each name comes
up, but I am having trouble finding a formula to put under each age criteria
which will count the amount of "Daves" that are >25, > 50, etc. Also It is
hard to figure out how to not double count the occurances, for example how
many daves are older than 25 but not 50?, not just how many daves are older
that 25.

Can anyone help me out

 

[Biff]

http://tinyurl.com/7djce

Biff