I'm sure this is easy but.....

[jimmisavage]

i have a column like this

yes
yes
no
yes
no
(blank)
yes
(blank)
no

i am looking for a formula to tell me how many times it says yes, no and (blank) in this column.

any help would be much appreciated. thanks

[VBA Noob]

Hi,

Try

=COUNTIF(A:A,"Yes")
=COUNTIF(A:A,"No")
=COUNTBLANK(A:A)

Change range as required

VBA Noob

[Bryan Hessey]

i have a column like this

yes
yes
no
yes
no
(blank)
yes
(blank)
no

i am looking for a formula to tell me how many times it says yes, no and (blank) in this column.

any help would be much appreciated. thanks

Hi,

try

="Yes = "&COUNTIF(A:A,"yes")&" No = "&COUNTIF(A:A,"no")&" (blank) = "&COUNTIF(A:A,"(blank)")

or use CountBlank is you wanted blanks.

hth
---

and Hi VBA Noob

[Carim]

Hi,

VBA Noob formulae are excellent ...

Just be careful with your blank cells ...
blank means empty ... it does not mean cells blanked with several spaces ...

HTH
Carim

[Teethless mama]

Hi,

Try

=COUNTIF(A:A,"Yes")
=COUNTIF(A:A,"No")
=COUNTBLANK(A:A)

Change range as required

VBA Noob

You can not use a whole column to count blank. You have to specify a range

[VBA Noob]

I did say

Change range as required

I would of assumed if he got a return of 64000 he may have guessed something was wrong

Plus Carim but a note in already if you read the thread " Just be careful with your blank cells "

VBA Noob

[Have a Go]

Is there a formula that can count anything other than yes or no.

i.e
if 5 boxes shows Yes
5 showed No
5 others had various stuff such as NA, blank etc

So in this case you would have Yes = 5 No = % Other =5 ?

Thanx

[Carim]

Hi,

Please Login or Register  to view this content.

HTH
Carim

[Have a Go]

Thanks for the speedy reply