Help with multiple COUNIFS & SUMIFS

Hi
Use in H8 adn copy down

Formula:

=IFERROR(IF(ISNUMBER(F8),COUNTIF($D$8:$D$103,D8)/SUMIF($D$8:$D$103,D8,$G$8:$G$103),""),"")

Use in I8 an array formula (you must enter with CTRL+SHIFT+ENTER) and copy down
=IF(ISNUMBER(F8),MAX(--($D$8:$D$103=D8)*$G$8:$G$103)/MIN(IF(--($D$8:$D$103=D8)*$G$8:$G$103>0,$G$8:$G$103,1E+99)),"")
In J8 use and copy down

Formula:

=IF(ISNUMBER(F8),$K$8/I8,"")

see the file