Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide formula | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Formula for counting specific cells which are greater than 1 | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |