Thread
:
Counting Characters in cells
View Single Post
#
3
Posted to microsoft.public.excel.misc
RagDyeR
external usenet poster
Posts: 3,572
Counting Characters in cells
Try this:
=SUMPRODUCT(--EXACT("H",J2:Z2))
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Brian Bermingham" <Brian
wrote in
message ...
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
Reply With Quote
RagDyeR
View Public Profile
Find all posts by RagDyeR