Counting Formula
 

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

Counting Formula
 

http://tinyurl.com/7djce

Biff

"Paul" wrote in message
...
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