Forumla for find total number of occurences, and then summing the value from the another cell

[PlusBob]

I have a column with employee names, and a column with hours they worked. There's a list of names, and next to the list I want it the result to be the total added hours for each name. Can you help?

In the example, Column D (Total Hours per Employee) is where I wish the formula to be:

A NAME	B HOURS		C List of Employees	D Total hours per Employee
John	1		Bob	2
Bob	2		John	5
John	1		Mark	2
John	3
Mark	2

<tbody>
</tbody>

 

[Marcelo Branco]

Try

D2
=SUMIF(A:A,C2,B:B)
copy down

M.

 

[PlusBob]

Well that easy! Here I'm trying to be all complex with it. Thank you Marcelo Branco!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.

 

[PlusBob]

I'm really not trying have anyone do my work .


Here's the formula that I have to count total number of entries for the month of October:
=SUMPRODUCT(--(MONTH('Timecard Detail FY16'!H2:H7601)=10))

And this is for total number of hours per employee
=SUMIF('Timecard Detail FY16'!E2:E7601,M3,'Timecard Detail FY16'!M2:M7601)

Sheet: 'Timecard Detail FY16' contains that data. Second sheet has the stats.

I'm trying to combine the two, so that I can show total number of hours per employee per month.

E Name	H date (mm/dd/yyyy)	M Hours per day		Stats Sheet M List of Names	Total # of Hrs/Emp/Month October	November	December
John	10/01/2015	2		Bob	6
Bob	10/01/2015	1		John	3
Mark	10/01/2015	4		Mark	7
John	10/02/2015	1
Bob	10/02/2015	5
Mark	10/02/2015	3

<tbody>
</tbody>

 

[Marcelo Branco]

Maybe something like this (adjust the ranges)

	A​	B​	C​	D​	E​	F​	G​	H​
1​	Name​	date (mm/dd/yyyy)​	Hours per day​		Year​	Month​	Name​	Hours​
2​	John​	09/30/2015​	5​		2015​	10​	Bob​	6​
3​	Bob​	09/30/2015​	5​				John​	3​
4​	Mark​	09/30/2015​	5​				Mark​	7​
5​	John​	10/01/2015​	2​
6​	Bob​	10/01/2015​	1​
7​	Mark​	10/01/2015​	4​
8​	John​	10/02/2015​	1​
9​	Bob​	10/02/2015​	5​
10​	Mark​	10/02/2015​	3​

Formula in H2 copied down
=SUMPRODUCT(--($A$2:$A$10=G2),--(YEAR($B$2:$B$10)=$E$2),--(MONTH($B$2:$B$10)=$F$2),$C$2:$C$10)

M.