Formulas to calculate multiple data validation responses

Hello,

I am in search of assistance in creating formulas that will help me ultimately aggregate a bunch of data and create a quick reference dashboard to view the summary of user inputs. I have attached an example workbook that explains what I am looking for. Essentially, it will require quite a few dependencies but I'm not quite sure what the most efficient and effective way would be to collect and analyze the data points. For example, in one section users should be able to select multiple selections given a list of options, but I don't know how I would do that and implement some of the things I am looking for.

Feel free to ask for clarification- it may seem a bit convoluted but I tried to explain it in the easiest way possible.

Thanks

Great, thanks for that. I'm off to a good start, but I still have quite a few cells that I need to figure out. Is some of this better suited to a formula, or is a macro still the better way?

Thanks