formula problems

[trinifrancis]

i have a worksheet with a list of students in the rows in the columns i have a question one for example and their marks, full marks represented by the number of points (5) for example under heading "y" in the next column if they answer wrong (0) under heading "n" and another column for a partial answer (3) for example under heading "p" what i need to do and am getting problems using null values with the "if" statement is to total the number of students who got question one correct,total wrong and total number of students who answered partially

Any help would be much appreciated
sandy

 

[SkipVought]

sandy,

You would help your cause is you were to paste a sample of your data and paste the formula that you are having problems with.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[trinifrancis]

i have a link to the file

http://www.box.net/shared/mkz1dzffdd

hope i dont violate any rules using box.net

 

[SkipVought]

Some of us have company security that prohibits us from downloading material from the net.

Please PASTE an example as previously requested including the formula in question.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Kurupt55]

Hi Sandy

I have had a look at your spreadsheet and it looks like a count function would do nicely

=COUNT(B4:B41)/COUNTA($A7:$A41)

This is assuming that you want to automatically calculate th percentages.
If you put that formula into cell B48 on your mathematics sheet this will calculate the percentage of correct answers.

Impossible is Nothing

 

[Kurupt55]

Just had another look and if you are trying to get the percentage mark for each student the formula will be

=SUM(B7:AN8)/SUM(B$2:AN$2)

In cell AO7

Impossible is Nothing