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.

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

Thanks i got it