Filling form with excel formulas

[JOGINDER SINGH]

Hello everyone.

I have attached a sheet. Please help to open that and fill the table with excel formula/function from G10 to I17 from the picking data from A9 to B30. 

[#2]

@JOGINDER SINGH 

=SUMPRODUCT(IFERROR((LEFT(SUBSTITUTE($A$9:$A$30,"BABAJI ",""),SEARCH(" ",SUBSTITUTE($A$9:$A$30,"BABAJI ",""))-1)=G$9),FALSE)*(IFERROR((RIGHT(SUBSTITUTE($A$9:$A$30,"BABAJI ",""),LEN(SUBSTITUTE($A$9:$A$30,"BABAJI ",""))-SEARCH(" ",SUBSTITUTE($A$9:$A$30,"BABAJI ","")))=$F10),FALSE))*$B$9:$B$30)

You can try this formula. Enter the formula with ctrl+shift+enter as an arrayformula.

[#3]

Thanks a lot dear for your help and giving your valuable time.