Hi,
Apologies for the (probably) terrible and non-specific title- I'm really struggling to summarise what I want to do concisely!
I'm trying to create a 'summary sheet' which performs a calculation on some data using criteria which the users selects from drop downs, see screenshot below:
Assuming the user must select something in each drop down, I found this easy- the table in columns X to AG just calculates using a SUMIFS (e.g. sum if the data in column ABC in the data sheet = C6, and if column ABD = C7 etc for each of the 5 criteria).
However what I'd like this to do ideally is allow the user to select any combination of specifications- i.e. they don't have to select a drop down for all 5. E.g. perhaps they want to calculate the response rates for all UK campaigns, or all UK skincare campaigns, not just UK+Skincare+Sachet+Youtube+Survey etc.
Is this possible in excel, and if so, how?
I've probably explained this terribly badly so let me know if you need further info- and I really appreciate any help in advance (even if its just to say sorry, no can do)
