Eliminating Duplicates from Count

**Janie** · 06-04-2012, 11:38 AM

Hello,
I am working on a excel sheet that lists employees by name, by date and # hrs each emloyees worked.
Example: attached

I would like to only count employees name once, but need the total # hours that employee worked. So for instance Employee Gould, J would equal 1, but total hours for that employee would be 6. I guess what I am trying to do is not count duplicate names, but still count all the hours. Anyone have any idea how I could acheive that? I have tried to subtotal but that still seem to count duplicate names seperately.
I'd appreciate any ideas.
Thank you.

**Pepe Le Mokko** · 06-04-2012, 11:42 AM

Perhaps a Pivot Table ? Count - Eliminating Duplicates.xlsx

**Fotis1991** · 06-04-2012, 12:01 PM

Hi

Or in D21 and copy down(Array formula C+S+E)

=IF(ISERROR(INDEX($D$5:$D$14;MATCH(0;COUNTIF($D$20:D20;$D$5:$D$14);0)));"";INDEX($D$5:$D$14;MATCH(0;COUNTIF($D$20:D20;$D$5:$D$14);0)))

In G21 and copy down.

=SUMPRODUCT(($D$5:$D$14=D21)*($G$5:$G$14))

Is this, works for you?

Edit: Pls, change the semi-colons in my formula to Comma if you have to do this..