formula problem
Hi
I am trying to analyse SAT results for my students
I have a column with their mark for each question
f8 to f24 for student A,
g8:g24 for student B
etc.
and a column that shows how many marks are allocated to each question c8
to c24
I want a boxes that have the following information in it.
Box 1 (which I have been able to do and it works)
to show how many students have less than 3 marks for each question
I used the formula:
=COUNTIF(F8:M8,"<3") for Question 1
=COUNTIF(F9:M9,"<3") for Question 2
etc.
Box 2
to show how many students have half marks or less than half marks per
question
the marks allocated to q1 is stored in cell c8
but this formula doesn't work
=COUNTIF(F8:M8,"<=C8/2")
any help would be much appreciated
--
Nospam
|