how do i make all the answers that are "correct" add up in percentage?? i have done the correct and try again....
+2
A:
Assuming that your table looks like this (where 1 means correct and 0 incorrect):
| A
---+-----
1 | 1
2 | 1
3 | 1
4 | 0
You can put the following into A10:
=AVERAGE(A1:A9)
to get the result
0.75
Peter Lang
2010-03-25 09:09:34
You could use AVERAGE instead of SUM()/COUNT(). For 0's and 1's, the Average is the same as the percent equal to 1.
Dan
2010-03-25 15:14:01
@Dan: Thanks, you are right - edited my answer.
Peter Lang
2010-03-25 15:19:08