count based on text

[MetLife]

Hi,

I have a column of records. Some start with the character "U" and some with "V".

I want to count if the starting character is "U" vs. "V". How do I do that in a single formula? I want to avoid using "IF(LEFT(A1 = "U",1,0)" for every record.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=COUNTIFS(A:A,"U*")

 

[MetLife]

OK thanks.

 

[Fluff]

Glad to help & thanks for the feedback.