You *did* say "letter answers", so ...

Assume name in Column A,
B to F for assignments.

In Column G, try this:

=--(COUNTIF(B1:F1,"*?")0)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Blah" wrote in message
oups.com...
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?