Counting only uppercase letters with wildcard in column/row
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!
|