Hello,
I have a document with 7 questions in 7 different columns. I am trying to count how many rows have any one of the 7 questions blank and I am struggling.
If I do a COUNTIF like this:
=COUNTIF({Q1 Answer}, ISBLANK(@cell), {Q2 Answer}, ISBLANK(@cell), {Q3 Answer}, ISBLANK(@cell), {Q4 Answer}, ISBLANK(@cell), {Q5 Answer}, ISBLANK(@cell), {Q6 Answer}, ISBLANK(@cell), {SQ7 Answer}, ISBLANK(@cell))
it will only count the row if all of the 7 questions are blank. I don't know how to formulate my formula, to count the row, if any of the 7 columns are blank. Is there any way to incorporate an OR in the "range" portion of my count if? I have not had much luck. Or is there another way to do this altogether?
Appreciate any help.