Counting only uppercase letters with wildcard in column/row

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Post the formula that you are using now that counts all cases


--


Regards,


Peo Sjoblom
 
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*")
 
Thanks for trying... unfortunately when using the formula I got a REF!
message. Any other suggestion?
 
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
 
Back
Top