Sum if based on two criteria and values in multiple rows and columns

welcome to the forum, Alkina. try this in M14:

Formula:

=SUMPRODUCT((LEFT($A$4:$A$39,FIND(" ",$A$4:$A$39)-1)=LEFT($L14,FIND(" ",$L14)-1))*(TEXT($B$2:$J$2,"mmyy")=TEXT(M$13,"mmyy")),$B$4:$J$39)

Rpened KG will not have anything because your data is "Ripened" instead. i find it based on the first word before the space

you can consider providing manually keyed answers next time too. that's so that we can check our answers