View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mwazir mwazir is offline
external usenet poster
 
Posts: 4
Default COUNT cells with Y and N

Hi All

I have a spreedsheet with a boolean column indicating 'Y', 'N' and sometimes
junk data.
Is there any function I can use to count the number of times 'Y' occures.

Thanks

--
Wazir