point assignment

B

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?
 
E

Elkar

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
 
R

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)
 
Top