point assignment

[Blah]

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?

 

[Guest]

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

 

[Mallycat]

in cell G2, enter =if(count(B2:F2)>0,1,0)

 

[Ragdyer]

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)

 

[Ragdyer]

Have you tried this with "letter" answers?