Thanks RD that works as well.
Brian

"RagDyeR" wrote:

Adjust for your range:

=SUMPRODUCT(--EXACT("H",J2:AN2))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"RagDyeR" wrote in message
...
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