1

Can I make this formula not count empty cells?

={"Score"; INDEX(if(len(A2:A), countif(if(REGEXEXTRACT(C2:BE,"(?i)yes")="yes", row(C2:C)), row(C2:C)),))}

1 Answer 1

1

Please use the following simple, still improved formula

={"Score"; 
   INDEX(IF(IF(LEN(B2:B), 
                COUNTIF(IF(REGEXEXTRACT(D2:G,"(?i)yes")="yes", ROW(D2:D)), ROW(D2:D)),)=0,"",
            IF(LEN(B2:B), 
                COUNTIF(IF(REGEXEXTRACT(D2:G,"(?i)yes")="yes", ROW(D2:D)), ROW(D2:D)),)))}

enter image description here

You will notice it is the same formula given before only this time we use an extra IF for when the result =0

2
  • So sorry for my late reply Kim. I totally missed your question. Apr 10, 2021 at 0:53
  • Thank you so much! I know I am being a real pain, but now when they answer no it won't count as zero. Is there any way to only get rid of the zero if the cells are blank? I know I may be asking for something impossible. I sure appreciate your help.
    – Kim
    Apr 11, 2021 at 5:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.