Supplier Survey Excel formula

With my picture I'm trying to figure out what formula to use when adding the number of points that a different from one another (8) and (28) to add up to (36 total points).

Yet have a different formula when entering the score.