SUM Formula and Logical Values

L

lank007

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

Teethless mama

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
 
L

lank007

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of values in column A based on 0/1 of column B 2
formula for arriving net difference 0
Sumif apllying to all sheets in workbook 2
Sum Function Visible Cells only 5
Multiple logic functions with multiple sums 2
adding multiple values from matched search results 3
Time Sum in Excel 1
Formula help needed 1

Top