I am trying to work out the formula for the following:

In two columns I have eight 20 assignments with scores added to each
assignment).

I then want to automatically grade these scores for each assignment where a
grade will have a different range of values. If the score falls into one of
the 12 grades, I want the cell to count one.

I've tried IF statements, LOOKUP but doesn't seem to work. Any help would be
appreciate. Thank you.