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 |