Background:
Our projects are divided into Categories on a spreadsheet and we have a
criteria for the overall Red, Amber, Green Status that we give for each
category.
I have managed to use the Countif formula to count the Red, Amber and Green
status for each catergory. I used a nested If statment but it keep returning
a #Value!

The criteria is % of Amber and/or Red is more than 30% of overall for that
category then it is Red.
If % of Amber and/or Red is more than 20% but less than 29% then overall
status for the category should be Amber.
If % of Amber and/or Red is less than 19% then overall status for the
category should be Green.
Please can someone tell me how I can use the above criteria on a range of
cells with percentages to be able to give me the Red, Amber or Green Status
for a category?