How can I add up letters or symbols in excel

G

Guest

I have excel 2003 and I want to be able to create a column with y's and n's
and count up the number of y's and n's

I also want to be able to do this with the letters b w a h o in order to
calculate the number of people from different races.

Any information you can provide would be appreciated
 
R

Ron Rosenfeld

I have excel 2003 and I want to be able to create a column with y's and n's
and count up the number of y's and n's

I also want to be able to do this with the letters b w a h o in order to
calculate the number of people from different races.

Any information you can provide would be appreciated
Click to expand...

Look at HELP for the COUNTIF function
--ron
 
G

Guest

This formula returns the count of cells with a value of "Y"
=COUNTIF(A1:A10,"Y")


Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
G

Guest

Terry said:
I have excel 2003 and I want to be able to create a column with y's and n's
and count up the number of y's and n's

I also want to be able to do this with the letters b w a h o in order to
calculate the number of people from different races.

Any information you can provide would be appreciated
Click to expand...
 

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
Count or sum help on query 1
Add only the cells after a particular number in the previous cell in the same column 1
How do I count how many times x appears in a column? 2
How do I calculate a percentage of a column? 2
question for excel how to have linked sum in column? 1
Adding Columns in Excel 1
cells contain letters need % in total cell 4

Top