#### Excel_beginner

##### New Member

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.