Sumproduct and Countif help

[Badvgood]

Hello all,

I need a formula that tells me how many unique WIP numbers each employee worked on from the data attached.

IE > I know that employee 4 worked on 49 unique WIP's (if ive counted it up correctly in my head!) but cant write a formula to do it.

I think I need SUMPRODUCT and COUNTIF but I can't get it to work.

Help, please.

Thanks

[PaulM100]

This will do:

=SUMPRODUCT((($B$2:$B$202=F2))/COUNTIFS($B$2:$B$202,$B$2:$B$202&"",$D$2:$D$202,$D$2:$D$202&""))

F2 is the employee number

[Badvgood]

This will do:

=SUMPRODUCT((($B$2:$B$202=F2))/COUNTIFS($B$2:$B$202,$B$2:$B$202&"",$D$2:$D$202,$D$2:$D$202&""))

F2 is the employee number

Perfect, thank you so much.

[PaulM100]

Happy to help