| Home |
| Search |
| Today's Posts |
|
#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 :) |
| 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) | |||
![Per Jessen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
