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.

	A	B
1	Total number	11
2	Correct	4
3	Incorrect	5
4	Spoiled	1
5

<tbody>
</tbody>

 

[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.