=+COUNTIF(D10:D240,"Yes") NOT WORKING

[Helder]

Hello all,

I know little about Excel that's why i am posting this message here.
I have a sheet with several columns, one of those columns have always
one of this 2 values: YES or NO

My question is, is there a way to count how many YES or NO are in that
column
and display the number in other cell?

I already tried =+COUNTIF(D10240,"Yes") but i get a msg saying
my form have an error.

Thanks in advance,
Helder
Portugal

 

[Max]

Tried out your :=+COUNTIF(D10240,"Yes") - works ok
(it did not give any error msg)

Try : =COUNTIF(D10240,"*Yes*")

 

[Helder]

ok, i tried this and worked: =SOMA.SE(D626;"OK") ----> soma.se means
count.if

The problem is: i have 3 OK between line 6 and 26.
On the cell the form is i have a 0

???????

 

[Bob Phillips]

Seeing Harald's post I omitted the Portuguese version of COUNTIF. I think
this might be what you want

=CONT.SE(D1024;"Yes")