Counting the number of cells with a number in a column

[RachelBrown]

I have a column in a spreadsheet that uses the =Left() function, what I end up with is rather: H, A, or a number. What I want to do is just count the number of cells with a number. I've tried a variety of things that I've seen from my Googling adventures, but haven't had any luck. Please help!

Here is a screenshot of what my column looks like:
The formula in A64 is =Left(D64,1) and changes respectively to the row

 

[Jonmo1]

Welcome to the board.

Try
=COUNTA(A:A)-SUM(COUNTIF(A:A,{"A","H"}))

Logic is Count how many non blanks there are COUNTA
Then subtract how many contain A or H.
Result must be how many contain a number.

 

[RachelBrown]

Welcome to the board.

Try
=COUNTA(A:A)-SUM(COUNTIF(A:A,{"A","H"}))

Logic is Count how many non blanks there are COUNTA
Then subtract how many contain A or H.
Result must be how many contain a number.

Thank you for your reply! Your formula did give me something besides zero, but it is still not right. The correct value should be 13 and I got 164 (and that's not even the sum of the values! ) Any other suggestions?

 

[jacobrcotton]

In column B, put in the code:

=if(iserror(Value(column A)), 0,1)

This will return a 0 if the value is a letter, a 1 if the value is a number. Then just sum up the 1's.

 

[RachelBrown]

Thank you! This worked.