SUM Formula and Logical Values
 

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?

SUM Formula and Logical Values
 

=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?

SUM Formula and Logical Values
 

You can get the result without having a third column
Assume their answers in column A, and correct answers in column B

=SUMPRODUCT(--(A2:A12=B2:B12))

Adjust your range to suit



"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?

SUM Formula and Logical Values
 

Sorry, I am new to this concept...the formula worked, but how do I add other
cells if they are all close together if that makes sense. If there are empty
cell between them that I don't want to select how do I do that. Because when
I set the range it take all the cell s from (for instance) E9:13=F9:F13 (it
takes E9,E10,E11,E12 and I just want E9, E11, E13)

"Teethless mama" wrote:

You can get the result without having a third column
Assume their answers in column A, and correct answers in column B

=SUMPRODUCT(--(A2:A12=B2:B12))

Adjust your range to suit



"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?