How to count only numbers in column

[janichohan]

Dear All;
i am facing some problem in counting the numbers actually i have one column and it contain thousands of data both in numbers and in strings/ alphabets.
can anyone help me in this regard how i can count only numbers out of it....

 

[Jimmypop]

Good day

Do you want to count how many cells in column contain numbers? Can use formula then (Formula below counts the amount of cells which contain a number value... just change the range to your requirement and place formula in cell where result should be...

=COUNT(A1:A22) (Result for Column A would be 8 cells containing numbers)

Do you want to sum cells in column containing numbers (All values added up)? Can use formula then (Formula below sums the amount of cells which contain a number value... just change the range to your requirement and place formula in cell where result should be...

=SUM(A1:A22) (Result for Column A would be 98)

Hope this is what you are looking for...

 

[janichohan]

Good day

Do you want to count how many cells in column contain numbers? Can use formula then (Formula below counts the amount of cells which contain a number value... just change the range to your requirement and place formula in cell where result should be...

=COUNT(A1:A22) (Result for Column A would be 8 cells containing numbers)

Do you want to sum cells in column containing numbers (All values added up)? Can use formula then (Formula below sums the amount of cells which contain a number value... just change the range to your requirement and place formula in cell where result should be...

=SUM(A1:A22) (Result for Column A would be 98)

Hope this is what you are looking for...

Hi thanks for the support but i am getting 0 in result by using this formula: i want the result like in attached image i have :

21 cells in Column ( A) while in Column (A)
8 cells contain number while all rest contain names of person

i want to get the result ( 8 ) which only counts the numbers in column (A)

 

[janichohan]

Hi thanks for the support but i am getting 0 in result by using this formula: i want the result like in attached image i have :

21 cells in Column ( A) while in Column (A)
8 cells contain number while all rest contain names of person

i want to get the result ( 8 ) which only counts the numbers in column (A)

Thanks For the Formula this works now as it need to convert teh data type if column then it will work fine ... i got my result

Stay blessed