trying to calculate blanks rows

Okay,
i am working on a nationwide prostate cancer database. There are some quetions we ask men that are a 7 part question that consists of 7 rows and can have multiple answers. I am trying to write an excel code that will go through each of these rows (for instance from cf2 to cm2) and tell me which people did not answer any of the questions). Is there a code i can write for this? let me know below is an example of what i'm working with

column A B C D
1. 0 0 0 0
2. 1 0 0 0

So i'm trying to find out how many people answered the question such as participant #1, who has zeros across the board. participant number 2 answered a question so he wouldnt count. any help would be GREAT!

do you know how i can write a code that counts the entire columns and just adds how many are missing??

yes, in each of the rows, 1 counts as yes, 0 as no answer. if someone answered at least one question, the value would be greater than one, if not, it would be considered "no answer" or missing...