How do I count how many times x appears in a column?

I

Ian Roberts

Hi

I have a table comprised of Y's and N's (which represent yes/no answers to
questions and categories).

I need to find the total number of Y's in each column.

I thought this would be simple but I've hit a wall!

I'd appreciate any help.

Thanks a lot.

Ian
 
N

Niek Otten

Hi Ian,

=COUNTIF(A3:A13,"Y")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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

Count the Y's in a filtered column that contains Y and N 1
Add only the cells after a particular number in the previous cell in the same column 1
How do I calculate a percentage of a column? 2
counting how many times a certain month appears 3
count how many rows a word appears in 1
number times a value appears in a column beside it chronological 3
Count the times a value appears in a column based on another value 6
how do i count how many times x in column a = 1 or 2 in column b 8

Top