Counting only uppercase letters with wildcard in column/row
 

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!

Counting only uppercase letters with wildcard in column/row
 

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!

Counting only uppercase letters with wildcard in column/row
 

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!

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!

Counting only uppercase letters with wildcard in column/row
 

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!

Counting only uppercase letters with wildcard in column/row
 

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




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

Counting only uppercase letters with wildcard in column/row
 

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

"TJA" wrote:

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!