Posting a workbook with no information in your post is just as bad, there is no question in your post. There should be enough information in your post to tell us what you want to do without opening the workbook. The workbook itself should only contain the data that is needed for us to work with.
See if this works
Formula:
=SUMIFS($D$2:$D$6,$B$2:$B$6,"Green",$C$2:$C$6,"South",$A$2:$A$6,"*"&A13&"*")
Note that if there are 2 or more rows in the top part where Shop, Colour and Area all match the criteria then the answer will be incorrect.
Bookmarks