| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding letters instead of numbers
I was curious if you could add how many "A" there were in a range.
i.e. If a1:a25 had an "A" in each cell, then how do you insert a function to eaual 25? -- Can :) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding letters instead of numbers
=COUNTIF(A1:A25,"a")
Change the range as needed "Can :)" wrote: I was curious if you could add how many "A" there were in a range. i.e. If a1:a25 had an "A" in each cell, then how do you insert a function to eaual 25? -- Can :) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding letters instead of numbers
Hi
If "A" is the only letter in the cell: =CountIf(A1:A25,"A") Regards, Per On 5 Aug., 00:53, Can :) wrote: I was curious if you could add how many "A" there were in a range. i.e. If a1:a25 had an "A" in each cell, then how do you insert a function to eaual 25? -- Can :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding numbers with letters | Excel Worksheet Functions | |||
| adding numbers but not letters | Excel Worksheet Functions | |||
| Adding a space inbetween letters and numbers in a cell | Excel Discussion (Misc queries) | |||
| adding numbers with letters | Excel Discussion (Misc queries) | |||
| FORMULAS FOR ADDING LETTERS REPRESENTING NUMBERS | Excel Discussion (Misc queries) | |||
Linear Mode
