=SUM(C:C)

If this post helps click Yes
---------------
Jacob Skaria


"lank007" wrote:

I am trying to use the Excel Workbook as an exam for my students. I have a
column for their answers and then a hidden column with the correct answers. I
have a third column that says IF the two columns match "true" then a 1
appears and if false a "0" appears....I would like my total column to give me
the sum of how many questions were answered correctly. How can I accomplish
that?