Assuming your Yes/No is in column A, try this:

=COUNTIF(A:A,"No")

Hope this helps.

Pete

On Apr 9, 10:27*am, TJ wrote:
I have a column that displays 'Yes' or 'No' Text. Does anyone know a function
to calculate the number of cells containing 'No'?
Thanks in advance of any help offered