Counting rows of blanks across certain columns
 

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)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"crossingboston" wrote in message
...
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?