One way:

=SUMPRODUCT((A1:A100=1)*(A1:A100<=9))

Regards

Trevor


"Anuja" wrote in message
...
hi!
But if the column contains the alphabets all the other it should only
discard the zero how can it be
Regards,
Anu

"Trevor Shuttleworth" wrote:

Anu

=COUNTIF(A:A,"0")

Regards

Trevor


"Anuja" wrote in message
...
Hi!
I need to put a formula so that it counts the numbers in a cell without
considering zero.If in a column there in a1=4,a2=3,a3=0 It should
return
the
value as 2.Please let me knoe the answer for this problem.My mail id is

Thanks,
Anu