Hi,
I have a large, growing, data set which has three values per row defined by multiple criteria.
I believe I can achieve the results within the table (below image) with a simple SUMIFS using criteria defined using drop-downs however I would like to simplify the drop downs (the data set is very large with multiple selections possible) e. g. if "Berries, Bananas and Citrus" is selected in the 'Section' drop down, the next 'Sub Section' drop down will only display selections which correspond in the raw data below.
Hope I've made sense, have hit a dead end
Snip.PNG
Bookmarks