View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Bermingham Brian Bermingham is offline
external usenet poster
 
Posts: 1
Default Counting Characters in cells

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