CODEWITHSUNDEEP
excelexcel-formula
Divyam Sureka
Divyam Sureka

Reputation: 1

Why isnt countif function in excel not working?

I wanted to count the number of cells that contain the digits '451011' in excel. So i converted all the cells to text first and then used the formula - =COUNTIF(A2:A28,"*451011*"), I had about 23-24 cells containing the same, but on evaluation the formula showed the answer as 2.

The Excel Screen

As you can see in the above picture, it shows the answer as 2. Please help.

Upvotes: 0

Views: 1516

Answers (1)

I like Excel very much
I like Excel very much

Reputation: 748

Try this formula:

=SUMPRODUCT(--(NOT(ISERROR(FIND(451011,A2:A28)))))

It will work for text or values.

Upvotes: 2

Related Questions