COUNTA counting formulas? How do I make it stop?

[Excel Hopeful]

I'm beat guys. I'm using counta to count alphanumberic items. It works, except it's picking forumulas. These column that is counted includes forumuals but soem retrun blanks.

How do I get around this?

 

[PaddyD]

describe your data in a little more detail - a worked example including the results you expect would help

 

[Excel Hopeful]

I have a list of alpha-numeric items in column A:

WR65
AI12
1FMC
45RT
" "
" "

These alpha-number items are pulled from other tabs within the workbook using the formula below:

=IF(ISBLANK(My!B12)=TRUE,"",My!B12)

There are times when the formula brings up BLANK values.

I'm trying to count the number of items in column A, but when I use CountA(A1:A6), I get 6 instead of 4.

 

[pgc01]

Hi Excel Hopeful

Try

=ROWS(A1:A6)-COUNTBLANK(A1:A6)

Hope this helps
PGC

 

[Scott Huish]

Try this:

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

 

[Excel Hopeful]

That works. Thanks

 

[CaptainNorthman]

Try this:

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

Thanks a lot!