Summarizing data into 1 list

Question

I am entering data for a time card summary report.  I have 2 employees and they work on multiple jobs/day and record hours spent on each job on for that day.  I enter each job title and hours for each day then I put a summary list together.  Is there a way excel can take data from one list with duplicate entries (with different hours) and produce a list with single entries?  It would be great if the hours were also summarized.

Example:

Input

AA - 2

BB - 3

CC - 1

AA - 3

BB - 1

CC - 6

Output

AA - 5

BB - 4

CC - 7

Answer 1

I tried it and changed it to mine but I get all zeros.

Answer 2

=sumproduct(--(A17=$A$1:$A$15),$B$1:$B$15)

I assumed you have 15 rows of data to summarize and the output start in A17 , change it for yours

Answer 3

Didnt quite do what I was looking for.  Here is the actual data.  I am looking directly below the original list.

      A                         B

Bertshe	2.50
Flying Foods	5.50
Encore	5.75
KMB	1.50
Skinner	0.75
Skinner	5.00
Clearlam	3.00
Clearlam	3.75
Skinner	1.00
Altivity	3.25
Altivity	8.00

Output:

A                          B

Altivity	11.25
Bertshe	2.50
Clearlam	6.75
Encore	5.75
Flying Foods	5.50
KMB	1.50
Skinner	6.75

Answer 4

Assuming you have AA, BB in Col A with corresponding hours in Col B (multiple entries for each).

If you have one entry for each AA, BB,... in Col C starting in row 1

then enter this formula in D1 and copy down

=SUMPRODUCT(--(A:A=D1),B:B)

this will give you the total for all entries against the value in C1 by adding together all hours in Col B

Answer 5

Hi, assuming that the names are in column A and the hs in column B, and in colum C you have a list of the names in D enter

=sumproduct(--(C2=$A$1:$A$1000),$B$1:$B$1000)

copy formula down