Excel Scoring System for columns

Create an excel sheet where I can score my columns based on categories and sub-categories. There are Two major groups. Likelihood & Impact. The end goal is to get a final Likelihood and Impact score for a bunch of risks. the max allowed score is 9 for both these groups. Each group is divided into 6 categories. Each category can have a max score of 1.5. Each category has 3 sub categories. Each sub category can have a value of 0 or .5. The categories and its subcategoreis for likelihood score is shown below. I need an excel sheet that can help me do this calculation where I can select the value of each sub-category (0 or .5) and I should have a total score of the category and then finally a total Likelihood score. The same will apply for Impact scoring. I can share the Impact details once the project is accepted. Both Likelihood and Impact scores have to co-exist in the same sheet. The elements I have to score will need both impact and likehood values calculated. Below is for Likelihood: Likelihood: 1. Exposure Level: (can have a max score of 1.5. Each subcategory can have a score of 0 or .5 which means that the max total for this category would be 1.5 and min will be 0) a. Public(External) Exposure: b. Ease Of Discovery: c. Ease of Exploit or known vulnerability: 2. Intrusion Difficulty:(can have a max score of 1.5. Each subcategory can have a score of 0 or .5 which means that the max total for this category would be 1.5 and min will be 0) a. Strength of Authentication b. IAM permissions c. Configuration of Network Security Measures 3. Breach Probability a. Historical Incidents b. Attack Frequency c. System Value 4. Encryption Status a. Relevance of Encryption Type b. Compliance with Encryption Standards c. Encryption Key Management and Controls 5. Configuration Complexity and Commonality of Misconfiguration Occurrence a. Complexity of Service Settings b. Common Configuration Errors c. Configuration Default Settings 6. Alignment with Pre-Exploitation Phases of MITRE ATT&CK and Cloud Threat Attribution a. Initial Access and Execution Risks b. Privilege Escalation and Defense Evasion c. Threat Actor Profiles and Attack Vector Analysis Total Likelihood Score: 3.5/9