Text counter

[makinmomb]

EV0298C40
EV300C39
EV320M6

Say I have that on a

what would be the formula to count those and get 3

[makinmomb]

Formula on b1

[Crisp Packet]

=COUNTA(Your_Range)

[Pete_UK]

Use this:

=COUNTA(A:A)

Hope this helps.

Pete

[makinmomb]

I have dragged the formula longer , thus I am getting say 300 instead of 255

[makinmomb]

Alkey yours almost worked , I get 301

[AlKey]

Alkey yours almost worked , I get 301

Then you have to set the ranges. like lest's say: A2:A300

=COUNTIF(A2:A300,"?*")

[makinmomb]

But my answer is 255

[makinmomb]

It counts a formula that has no data

[AlKey]

Then use this one

=COUNTIF(A:A,"?*")

[makinmomb]

If I manually highlight the data

[JohnTopley]

So what is your data: again illustrates the need to post a file as we cannot second guess your data!

[makinmomb]

I am not able to attach , it not works today , my net has issues

[Pete_UK]

Okay, describe what you have in column A. Do you have a heading(s)? Which is the first cell with that formula? What is the formula? Where has it been copied down to? Do you have anything else in that column?

Pete

[makinmomb]

The data is mix of text and alpha

EV0298C40
EV300C39
EV320M6

[makinmomb]

Those are extracted through formula

=IFERROR(INDEX($B$1:$B$9999,SMALL(IF((NOT(ISNUMBER(LEFT($B$1:$B$9999,1)+0)))*($B$1:$B$9999<>""),ROW($B$1:$B$9999)-ROW($A$1)+1,""),ROWS($A$1:A1))),"")

[makinmomb]

The file , let me see if it attach

[Pete_UK]

The formula in E1 should be:

=COUNTIF(D:D,"?*")

not COUNTA.

Hope this helps.

Pete

[makinmomb]

Oh , Alkey was correcr