Writing a rule for a range of cells

[jlebar]

I am trying to write a rule for a range of 5 cells B9:B13. I want rule read something like this......
IF there are no "X's" a score of 1 is shown in B15.
IF there is 1 "X", or 2 "X's", a score of 2 will show in B15.
IF there is 3, 4, or 5 "X's" a score of 3 will show in B15.


Does anyone know how to write this formula?

Thanks,
Jason

[Jonmo1]

Try

=MATCH(COUNTIF(B9:B13,"X"),{0,1,3})

[ChemistB]

=if(countif(b9:b13,"x")<1, 1, if(countif(b9:b13,"x")< 3, 2, 3))

[jlebar]

Skill Assessment.xlsx

Here is 6 different examples of what the sheet would look like, now I just need the formula. The rubric is up top and each assessment follows those rules with the outcomes . The two formulas you gave me didn't work, but I think it's close. I've tried to play with them and still cant get them to work.

[ChemistB]

Not sure what you did wrong but I pasted Jonmo1 and my formulas directly into your worksheet (made a copy for each of us) and they worked fine. Can you point me to which cell is not working?

[jlebar]

Yeah, not sure what I did either, because now it is working. Thank you both very much. This is going to be a huge time saver for me.

Jason

[Jonmo1]

You're welcome