Thread
:
Counting Characters in cells
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
Posts: 5,651
Counting Characters in cells
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
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld