| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format logical values | New Users to Excel | |||
| Formula help - need to be able to sort alpabetically so logical values don't work | Excel Discussion (Misc queries) | |||
| If, Logical Values. | Excel Discussion (Misc queries) | |||
| SUM for logical values | Excel Discussion (Misc queries) | |||
| Adding logical values | Excel Discussion (Misc queries) | |||
Threaded Mode
