Forum Discussion
Filling form with excel formulas
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 Replies
=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.
- Thanks a lot dear for your help and giving your valuable time.
