| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I add up letters or symbols in excel
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add up letters or symbols in excel
On Wed, 21 Feb 2007 18:44:05 -0800, Terry
wrote: 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 Look at HELP for the COUNTIF function --ron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add up letters or symbols in excel
This formula returns the count of cells with a value of "Y"
=COUNTIF(A1:A10,"Y") Does that help? *********** Regards, Ron XL2002, WinXP "Terry" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add up letters or symbols in excel
"Terry" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| My Excel cols have #s, not letters. How get letters? | Excel Worksheet Functions | |||
| Counting letters and symbols | Excel Worksheet Functions | |||
| How do I add symbols above the letters? | Excel Discussion (Misc queries) | |||
| Changing letters to symbols | Excel Discussion (Misc queries) | |||
Linear Mode
