Function help

  • Thread starter Thread starter TJ
  • Start date Start date
T

TJ

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
 
Assuming your Yes/No is in column A, try this:

=COUNTIF(A:A,"No")

Hope this helps.

Pete
 
Back
Top