Hi
I have an audit template where we have a set of scored criteria.
each one marked green = 5 points
amber = 3 points
red = 0 points
We add up all the the score, using aggregate(9,6,range)
We then calculate a %age grade using a simple divide total by max possible total formula
This works...