Text counter

EV0298C40
EV300C39
EV320M6

Say I have that on a

what would be the formula to count those and get 3

Formula on b1

=COUNTA(Your_Range)

Use this:

=COUNTA(A:A)

Hope this helps.

Pete

It counts a formula that has no data

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

Alkey yours almost worked , I get 301

But my answer is 255

If I manually highlight the data

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

The data is mix of text and alpha

EV0298C40
EV300C39
EV320M6

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

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

Those are extracted through formula

Please Login or Register  to view this content.

The file , let me see if it attach

The formula in E1 should be:

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

not COUNTA.

Hope this helps.

Pete

Oh , Alkey was correcr