This is the current formula... It will count only the letter "y" with
wildcard, regardless if it is upper or lower case. I would like it to count
only uppercase with wildcard. Thanks for your response.

=COUNTIF(B4:B7,"y*")

"Peo Sjoblom" wrote:

Post the formula that you are using now that counts all cases


--


Regards,


Peo Sjoblom



"TJA" wrote in message
...
I'm working with columns and/or rows containing both upper and lower case
letters with wildcards. I only want to count upper case letters with
wildcards. Any help to this problem will be greatly appreciated. BTW I'm
using excel 2007. Thanks!