| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
caculations letters
how can i have excel count letters instead of numbers
if i have a row of cells a b a a b c a b how can i set up a cell to give me the total number of all the a's in the row |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
caculations letters
=COUNTIF(A1:H1,"a")
RBS "lifeguardernie" wrote in message ... how can i have excel count letters instead of numbers if i have a row of cells a b a a b c a b how can i set up a cell to give me the total number of all the a's in the row |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
caculations letters
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
caculations letters
For the whole row...
=COUNTIF(1:1,"a") Rick "lifeguardernie" wrote in message ... how can i have excel count letters instead of numbers if i have a row of cells a b a a b c a b how can i set up a cell to give me the total number of all the a's in the row |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
| Multiple caculations using individual data | Excel Worksheet Functions | |||
| How to perform caculations using database functions in this case | Excel Discussion (Misc queries) | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| perform caculations on displayed value in Excel 2000 | Excel Worksheet Functions | |||
Hybrid Mode
