PS - I had originally hoped that the criteria would ALWAYS read from
left to right, in which case Debra's solution would at least work.

I now don't think that will be the case: there may be some gaps - ie
someone may fill in criterias 1, 3, and 5, leaving 2 and 4 blank.

If that's the case, the nested IFs won't work.

Any ideas?