Thanks for trying... unfortunately when using the formula I got a REF!
message. Any other suggestion?

"Peo Sjoblom" wrote:

Try

=SUMPRODUCT(--(EXACT(LEFT(B4:B7),"Y")))



--


Regards,


Peo Sjoblom



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