point assignment

  • Thread starter Thread starter Blah
  • Start date Start date
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?
 
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
 
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)
 
Back
Top