LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
nkidd
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAY function problem - starting on weekends [email protected] Excel Discussion (Misc queries) 5 June 16th 05 10:55 PM
count if function with if statements Natalia Excel Worksheet Functions 3 April 22nd 05 02:52 AM
"count if" function based on value of another cell Anauna Excel Worksheet Functions 3 February 24th 05 06:33 PM
How can I use count function in excel where I have several criter. Princess V Excel Worksheet Functions 14 November 3rd 04 10:18 PM
Sum and Count Function Daniell Excel Worksheet Functions 0 November 2nd 04 12:03 AM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"