Not sure what formula to use (Tried CountIF and MAXIFS)

[Beardybrady]

Hello All,

I hope you can help me, I've started a new role in my company and been tasked to make a programme management system using excel currently to do this to manage budgets, Risk etc etc

To help me with this I have created a separate excel spreadsheet for the Project Managers to manage their induvial budgets, I will then get the information off this and feed it into the master sheet I am developing.

So, I have produced a risk register with conditional formatting for current risk and residual risk, at the bottom a table then pully through the numbers based on their severity using a countifs function using great or equal than.

What I want to do on the main sheet is to pull the highest value into a cell and to display whether it be low risk, medium risk high risk etc.

I have attached a image, hope this shows enough information let me know if you need anything else

 

[awoohaw]

the image is very small and not very easy to read. There is an add in, xl2bb (link below) that you can you to post mini worksheets and allow the forum to help you much better.

 

[Beardybrady]

the image is very small and not very easy to read. There is an add in, xl2bb (link below) that you can you to post mini worksheets and allow the forum to help you much better.

Thanks for this, It is on my work laptop so wouldn't be able to install any add-ins unfortunately ill see if i can enlarge it