khalid79m
02-11-2009, 08:06 AM
.Formula = "=IF(COUNTBLANK(INDEX(Question_1,ROW(A1)))+COUNTBLANK(INDEX(Question_2,ROW(A 1)))+COUNTBLANK _
(INDEX(Question_3,ROW(A1)))+COUNTBLANK(INDEX(Question_4,ROW(A1)))+COUNTBLAN K(INDEX(Question_5,ROW(A1))) _
+COUNTBLANK(INDEX(Question_6,ROW(A1)))+COUNTBLANK(INDEX(Question_7,ROW(A1)) )+COUNTBLANK(INDEX(Question_8, _
ROW(A1)))+COUNTBLANK(INDEX(Question_9,ROW(A1)))+COUNTBLANK(INDEX(Question_1 0,ROW(A1)))+COUNTBLANK _
(INDEX(Question_11,ROW(A1)))+COUNTBLANK(INDEX(Question_12,ROW(A1)))+COUNTBL ANK(INDEX(Question_13,ROW(A1))) _
+COUNTBLANK(INDEX(Question_14,ROW(A1)))+COUNTBLANK(INDEX(Question_15,ROW(A1 ))),""O"",""P"")"
this simply counts blanks in the named range and dispalys o or p. I need the formula to count only to question 7 if the range named "CHECK" is equal to 1 and if its then count question 1,2,3,5,6,7 (missing question 4)
in a nut shell if range CHECK is equal to 1 then Countblanks for Questions 1 to 7 , but if it is 2 the Countblanks for question 1 to 3 and 5 to 6.
Can anyone help. Spent a whole day on this :(
(INDEX(Question_3,ROW(A1)))+COUNTBLANK(INDEX(Question_4,ROW(A1)))+COUNTBLAN K(INDEX(Question_5,ROW(A1))) _
+COUNTBLANK(INDEX(Question_6,ROW(A1)))+COUNTBLANK(INDEX(Question_7,ROW(A1)) )+COUNTBLANK(INDEX(Question_8, _
ROW(A1)))+COUNTBLANK(INDEX(Question_9,ROW(A1)))+COUNTBLANK(INDEX(Question_1 0,ROW(A1)))+COUNTBLANK _
(INDEX(Question_11,ROW(A1)))+COUNTBLANK(INDEX(Question_12,ROW(A1)))+COUNTBL ANK(INDEX(Question_13,ROW(A1))) _
+COUNTBLANK(INDEX(Question_14,ROW(A1)))+COUNTBLANK(INDEX(Question_15,ROW(A1 ))),""O"",""P"")"
this simply counts blanks in the named range and dispalys o or p. I need the formula to count only to question 7 if the range named "CHECK" is equal to 1 and if its then count question 1,2,3,5,6,7 (missing question 4)
in a nut shell if range CHECK is equal to 1 then Countblanks for Questions 1 to 7 , but if it is 2 the Countblanks for question 1 to 3 and 5 to 6.
Can anyone help. Spent a whole day on this :(