I have 96 students and want to determine how many students missed a
particular question (40 in all). I don't need to know the particular
students as I'm just trying to find out how many students missed a particular
question.

I have a spreadsheet which lists the question number in column A (i.e. 96
1's, 96 2's, 96 3's, etc) and in column B either a 0 (if the question were
missed) or a 1 (if the question was answered correctly)

I want a formula which will give me the number of students who missed
question 1, question 2, etc.

I've been trying to come up with a formula that will perform if column A
between cells A1 and A3840 is 1 (for question #1) then add all the zeros for
this same set (A1:A3840 if 1 and if 0).

This won't let me sleep...please help!