Need to add numbers in Column B if number in Column A is same

[smyoung6670]

I am working on compliling a list of fitness members usage rate. I want to analyze this from month to month, so what I do is input every week which has it broken down into every day usage. So column A has the member's employee # and column B has their weekly uses. The problem is that column A shows every time the employee came to use the facility and Column B only shows each week's break down for the month. See the attachment for what it is and what I want it to look like. How can I do this with sumif or sumifs? Is there a better way? I tried a pivot chart but I still have to add the weeks and if someone uses the facility 3 times a week for a month, the pivot chart only shows 3 instead of 3,3,3,3. I essentially want the numbers in column B to added only if they have the same number next to them in column A and then consolidate that list so each person's employee # is shown with their total uses for the month.
Thank you!

[dredwolf]

In the attachment I'e supplied 2 different solutions, the countif column counts the number of times the employee number shows up in column b, the sumif one sums the column c values if the column b value eqauls the employee number..there are a few diffences between the 2, not sure if they are input errors, or part of the problem you are describing above...see which one is more accurate

Hope this helps

[smyoung6670]

That all makes sense, but how do I make the countif formula tally each time the number is listed. That is exactly what I want but if I just have a massive list with the emp #'s, how can I consolidate it to each employee number with the amount of times that number occurs? I'm terrible with formulas.

[dredwolf]

I'm not sure what you mean...thats what the solution I posted did, found all the unique employess, and counted how many times they appeared...you STILL need the base data to work with