So, if the student did not answer in an assignment, then would the cell be
blank? If so, then the COUNTA function might work for you:

=COUNTA(B2:F2)

This would count the number of non-blank cells in the range B2 through F2.


=IF(COUNTA(B2:F2)0,1,0)

This returns a 1 if any cell in the range contains a value, and a 0 if no
values are present.

HTH,
Elkar


"Blah" wrote:

I have 200 rows of students and 5 columns of assignments with letter
answers in each one. I want to give one point if the student answered
in at least one assignment and zero if they did not...any formula which
could do this?