Code:
And I have the following information:
Score Target Month 1 Month 2 Month 3 Month 4 Month 5 Month 6
2 90 100 100 100 100 100 0
If you create a lookup table off to the right indicating what "counts" begin what score level (see picture) then you can simply COUNT how many cells are >= to your target score in that lookup table and pull back the appropriate score.