How to avoid Text values in column

[ramrongala]

Hello Guys,

Please help on below problem.

i have one column(No of count) and i want sum the columns like =sum(No of count), its showing 0.

i tried different ways but no luck.

I want to sum or avoid text values in the columns.

sum=165, please have look below table and help me.  

No of count
2
3
5
9
20
30
96
Rana
testing

[sunny_talwar]

Awesome, I hope you will be able to find the issue.

Best,
Sunny