Counting only uppercase letters with wildcard in column/row

[Guest]

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!

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[Guest]

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]

Try

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



--


Regards,


Peo Sjoblom

 

[Guest]

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

 

[Peo Sjoblom]

You must have copied it incorrectly, it certainly works. REF errors come
from when you reference a cell that doesn't exist for instance if you
reference A1 and then you delete the first row.
There is no way that formula can return a REF error if pasted correctly,
besides it returns the same result as the formula you posted except that it
counts strings that start with uppercase Y


--


Regards,


Peo Sjoblom

 

[Guest]

You were correct.... I copied the formula incorrectly. Thank you!!!