COUNT cells with Y and N

  • Thread starter Thread starter mwazir
  • Start date Start date
M

mwazir

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
 
Hi

=COUNTIF(A1:A100,"Y")

where A1:A100 is the range of your data

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find value in a column and insert rows above 12
Problem with UDF 2
Y/N and print job sequencer 10
Sumproduct with double quoted strings 1
Finding last appearance of given value 6
EXCEL COUNTIF FORMULA 0
Function needed to pull in cell values 9
Copy rows to another sheet 6

Back
Top