In the attached spreadsheet is a worksheet named 'Analyse' and in here is some sums. I need to build into the sum a filter so that I can get more specific results.
In the worksheet named 'Master Sheet' column 'G' are some product codes and I would like to build into the sum the ability to be able to filter results by the start of a product code so that I can see specific results filtered by code. I don;t want it to search by the whole code though so as an example I have two codes PJ5055DYEC & PJ5055DYEB, rather than the whole code I want to filter by PJ5055DYE as then I get the results for every code starting with these digits.
Any help greatly appreciated.