Return text based on value from predefined range

i have a question, i understand about =sum
it total all the amount that we type in, but i dont know how to do like this in the picture
question.png

my total point is 81/100, but i dont know how to do the formula.
example
gold - the point is 90.00 to 99.99
silver - 80.00 to 89.99

i want my total amount auto fill in the silver column because the average point is in around silver average point.

how can i set, when the amount that i get it will detect and fill in the correct column

how can i do that

pls help me, thx