| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Characters in cells
"Ron Rosenfeld" wrote: On Tue, 23 Jun 2009 08:11:01 -0700, Brian Bermingham <Brian wrote: Hi I want to count the number of cells containing a particular uppercase character. I tried using =COUNTIF(J2:AN2,"H") but this counts lowercase as well. Is there any way to count upper case or lower case only? I am using Excel 2007 Thanks Brian Try: =SUMPRODUCT(--ISNUMBER(FIND("H",J2:AN2))) --ron Thanks ron that woks fine. Just so I understand, the character is being compared as a number and as upper case and lower case have diffeten values only the specified version is counted? Thanks Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting characters | Excel Worksheet Functions | |||
| Counting Characters | Excel Worksheet Functions | |||
| Counting characters | Excel Discussion (Misc queries) | |||
| counting characters in a line | Excel Discussion (Misc queries) | |||
| counting characters issue | Excel Worksheet Functions | |||
![Brian Bermingham[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
