Excel_beginner
New Member
Hello friends!
My first post here.
I have 8 columns containing values yes or no. However, there are also blank values in many cases.
My aim is to count the numbers of times "yes" occurs.
When applying =COUNTIF(A2:H2;"yes") the formula shows = 0 when A2:H2 is blank.
This is not good since it also shows =0 when A2:H2 is ="no".
I need somehow to separate true 0 (i.e ="no") from blanks, which are set to 0. I believe I need to combine IF with COUNTIF, but I'm not sure how to write the formula. Can anyone pleas help? Thanks in advance.
My first post here.
I have 8 columns containing values yes or no. However, there are also blank values in many cases.
My aim is to count the numbers of times "yes" occurs.
When applying =COUNTIF(A2:H2;"yes") the formula shows = 0 when A2:H2 is blank.
This is not good since it also shows =0 when A2:H2 is ="no".
I need somehow to separate true 0 (i.e ="no") from blanks, which are set to 0. I believe I need to combine IF with COUNTIF, but I'm not sure how to write the formula. Can anyone pleas help? Thanks in advance.