CODEWITHSUNDEEP
excelvba
YasserKhalil
YasserKhalil

Reputation: 9548

COUNTIF with partial criteria doesn't work

I am trying to use simple formula with Countif and the criteria is partial text Example: say the range is A25:A32

10060019
10060020
10060021
10060022
10060023
10060024
10060025
10060026

And when I used this formula

=COUNTIF(A25:A32,"*" & 1006 & "*")

I got 0.. And that's weird for me as this was working for me before.

I am using Office 365 32 Bit.

Is there a bug in that version .. or what?

Upvotes: 1

Views: 242

Answers (1)

Sharif Lotfi
Sharif Lotfi

Reputation: 574

If Range A25:A32 has Number format , use this formula istead : =COUNTIF(A25:A32,">" & 1006) . otherwise you should renew A25:A32 values to Text format to use formula : =COUNTIF(A25:A32,"*1006*")

Upvotes: 2

Related Questions