Calculate yes

[ajaykr333]

Dear,
I have an spread sheet. In this there is colunm where it it written 'Yes', 'No' & 'spaces'
I want to count number of yes and number of no and number of not written means spaces.

Can anyone suggest me what fuction i should use to get my answer.

 

[Nareik]

Use the =countif(....) function.

Help describes it quite well.

 

[ajaykr333]

Thanks,
But In COUNTIF fuction what does criteria means. What shoul i write In That.

 

[tav1035]

ajaykr333,
Column Count Formula
Yes 6 =yes =COUNTIF(H:H,"yes&quot
Yes 5 =no =COUNTIF(H:H,"no&quot
no 2 =space =COUNTIF(H:H," &quot
no 2 =blank =COUNTIF(H:H,"&quot
yes

yes

no
yes

no
tav
yes

no