Number of Cells in a column

[Jack]

Hi,

I want to add this formula in my ESS.
COUNTIF(sheet1!S2:S43,"*Yes*") to find out
the number of value containing "YES".
My concern is I don't have fixed count from
S2 to S43. It could be something else.
What can I do to have this code reusable?

I thought something like

COUNTIF(Sheet!S2:Count($S2),"*Yes*")
\But it doesnt work

Thanks for your help
Jack

 

[Ken Wright]

Try this if there is nothing else in that column:-

=COUNTIF(sheet1!S:S,"*Yes*")