CODEWITHSUNDEEP
excel
RuiGene
RuiGene

Reputation: 1

Return the number of occurrences of a number

enter image description here

Right now my issue, is that if I want to search for '263', it returns 0 as I believe excel thinks the entire cell is one string.

I have tried using FIND and SEARCH but it doesn't return the correct number.

Upvotes: 0

Views: 55

Answers (2)

Solar Mike
Solar Mike

Reputation: 8375

So, just to clarify my comment adding to @Dominique :

enter image description here

And, you will notice it only captures 1 for the entry in cell A5

You can try each of the following:

COUNTIF(A1:A6,"*263*")

COUNTIF(A1:A6,"263*")

COUNTIF(A1:A6,"*263")

COUNTIF(A1:A6,263)

Separately to see what happens.

Upvotes: 0

Dominique
Dominique

Reputation: 17493

I just managed as follows:

=COUNTIF(A1:A6,"*263*")

Be aware that an entry like 263 lab | 263 will yield 2 count results.

Upvotes: 1

Related Questions