Counting rows of blanks across certain columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a survey whose answers were recorded in Excel. The answers for a
particular question extend from Q6 to Z505. I need to count the people who
did not answer the question (that is, the people, entered in rows 6 to 505
that left columns Q through Z blank). I'm not sure how to do this. Can
someone offer a suggestion?
 
Hi

You can use a formula like this in Column AA
=IF(COUNTA(Q6:Z6)=0,1,"")
copy down till AA505

You can use a simple Sum formula now to count the empty ones
=SUM(AA6:AA505)
 
Back
Top