Productivity Calculation

Hi,

Kindly help with the formula for productivity of the employees who have completed the orders.

attached is the sample sheet.

Regards
rush.

Thanks i got it

It's not clear exactly how you want it to look, but you could use something like the table in my attachment, which uses:

=IFERROR(INDEX($F$2:$F$50,SMALL(IF(COUNTIF($H$2:$H2,$F$2:$F$50)=0,ROW($F$2:$F$50)),ROW(1:1))-1),"")

...filled down to return the names. The formula should be array-entered (Ctrl + Shift + Enter). Then the following for the data:

=COUNTIFS($F$2:$F$50,$H3,$C$2:$C$50,">="&$I$1,$C$2:$C$50,"<="&$K$1,$D$2:$D$50,I$2)

Fill right and down. See the attachment for a clearer picture:


EDIT: You can change the dates in row one to select a different date range