Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count function problem
I am trying to make a spreadsheet that counts how many times a certain name
in collum A and a certain number in collum B appear. In collum A, I have a list of people's names. Each name may appear multiple times. In collum B, I have a list of numbers ranging from 1-12 which stand for months (1 for Jan, 2 for Feb, etc). On another worksheet, I have each person's name in collum A listed once. In collum's B-M i have the months listed out at the top as collum labels. Collum N is used for a "total". I need to have it count how many times a certain person's name appears next to each number and put this in the correct month. For example lets say the name "Kevin" appears 4 times on the list on the first worksheet. The first two times the name has a 3 next to it in the number collum, one time has a 10 and the other time it has a 4 next to it. On the 2nd worksheet in the Kevin row, I need it to put in a 2 in the March collum, 1 in the October collum, and a 1 in the April collum. Please let me know if you need any more information to help me. Thank you very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAY function problem - starting on weekends | Excel Discussion (Misc queries) | |||
count if function with if statements | Excel Worksheet Functions | |||
"count if" function based on value of another cell | Excel Worksheet Functions | |||
How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
Sum and Count Function | Excel Worksheet Functions |