CountIF formula criteria with text

[Npet]

I have probably a basic Excel formula situation, but I'm having trouble figuring out this scenario. Thank you for videos as they have been very helpful.

See table below and formula...


Assumptions:
Table range A1:B5 is named "loc"

Formula:
countif(Loc[Address], "Left(Loc[Address],2)=10")

My result is a column of 0's where the formula is placed.
Can COUNTIF not compare text? Or is there a better way to do this?

My expected result is to see there a count of 3 rows with an address that starts with "10"

A​	B​
Location​	Address​
Christchurch	192.168.1.2
Hammond	10.54.6.7
Frankville	10.23.45.67
Cityville	10.3.4.5

Thank you for any advice.

 

[bosco_yip]

Try,

In D2, enter formula :

=COUNTIF(B2:B5,"10*")

or

=SUMPRODUCT(0+(LEFT(B2:B5,2)="10"))

 

[pecoflyer]

countif(Loc[Address], "Left(Loc[Address],2)=10")

Shouldn't it be countif(Loc[Address], Left(Loc[Address],2)="10")

 

[Npet]

Try,

In D2, enter formula :

=COUNTIF(B2:B5,"10*")

or

=SUMPRODUCT(0+(LEFT(B2:B5,2)="10"))

View attachment 80856

Thank you,
I didn't realize I could use a wildcard there.