Create formula to count category risk with aggregate rating
I have a risk register for a project that has well over 100 risks documented and I have them categorized into 17 different risks. I would like to be able to create a formula to count how many risks exist under each category and then a formula to show the aggregate risk associated with this. I would think by a weighting? 1 for low, 3 for medium, 9 for high?
I have extracted and mocked up (in excel to show what I want it to show) to be able to display on a dashboard.
Any help would be greatly appreciated :)
Help Article Resources
Check out the Formula Handbook template!