Need a Formula to Calculate Production Numbers

[Lasantha]

Dear Team,

Kindly look in to the attached excel file. Could you please give me a formula to calculate production numbers of each users according to following details.

1. I need production numbers between given date range.its manually inserts.i am changing date range weekly.
2. Users - Unique names of column D (user column)
3. Production Count - Count of FALSE of between given date range of relevant user.
4. Production $ - Sum of Column E of between given date range of relevant user.

Thank you,
Lasantha.

 

[Chihiro]

In H8:
=INDEX($D$2:$D$188,MATCH(0,IF(($C$2:$C$188>=$H$5)*($C$2:$C$188<=$I$5),COUNTIF($H$7:H7,$D$2:$D$188),""),0))

Confirmed as Array (CTRL + SHIFT + ENTER)
Copy down.

Rest is simple countifs & sumifs.
I8:
=COUNTIFS(B:B,"FALSE",D:D,H8,C:C,">="&$H$5,C:C,"<="&$I$5)
J8:
=SUMIFS(E:E,D:D,H8,C:C,">="&$H$5,C:C,"<="&$I$5)

 

[Chihiro]

On second thought, you could just use PivotTable instead of formulas.

See attached.

 

[Lasantha]

In H8:
=INDEX($D$2:$D$188,MATCH(0,IF(($C$2:$C$188>=$H$5)*($C$2:$C$188<=$I$5),COUNTIF($H$7:H7,$D$2:$D$188),""),0))

Confirmed as Array (CTRL + SHIFT + ENTER)
Copy down.

Rest is simple countifs & sumifs.
I8:
=COUNTIFS(B:B,"FALSE",D:D,H8,C:C,">="&$H$5,C:C,"<="&$I$5)
J8:
=SUMIFS(E:E,D:D,H8,C:C,">="&$H$5,C:C,"<="&$I$5)

thank you so much...

 

[Lasantha]

On second thought, you could just use PivotTable instead of formulas.

See attached.

thank you very much for your time.