Formulate without a adding a new cell of data

[The Grim Discovery]

People

I've got this scenario and I've been scratching my head over this for a while today.

It's a small survey of 11 participants (b1) who were asked to answer a question.
4 got the answer right (B2), 5 got it wrong (B3) 1 spoiled the paper (B4) but, and this is what's catching me out, 1 didn't answer. I need to be able to add that 1 to the total of B3 (making it a new total of 6). But can I do this without adding another cell of data ie. can I calculate this using only the values in B1:B4. My efforts in formulating this so far have only resulted in circular reference warnings and wrong answers. Maybe it cant be done. Maybe I'm missing something obvious. Thanks as ever.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Total number
[/TD]
[TD]11
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Correct
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Incorrect
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Spoiled
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

In B3 enter the formula =B1-B2-B4 and then you only need to complete cells B1, B2 and B4 and B3 will always give you the remaining number (Incorrect &/or missing)

 

[The Grim Discovery]

Thanks Peter, just what I wanted and couldn't for the life of me see.

 

[Peter_SSs]

Thanks Peter, just what I wanted and couldn't for the life of me see.

No problem, glad to help.