How can i give formula to count the only numbers except zero in a

[Guest]

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
(e-mail address removed)
Thanks,
Anu

 

[Trevor Shuttleworth]

Anu

=COUNTIF(A:A,">0")

Regards

Trevor

 

[Guest]

hi!
But if the column contains the alphabets all the other it should only
discard the zero how can it be
Regards,
Anu

 

[mark.dubbelboer]

Try a sumproduct:

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]

One way:

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

Regards

Trevor

 

[Guest]

Hi!
The column should accept all the things like alphabets,sp.char,numbers but
should discard only zero.I am sorry for asking once again.Please let me know
the answer.Please.
Thanks and Regards,
Anu

 

[Trevor Shuttleworth]

The question you posed was "How can I give formula to count the *only
numbers* except zero"

Whatever, try this:

=COUNTIF(A1:A15,"<>0")

Regards

Trevor

 

[Guest]

Hi!
Thanks a lot . Trevor it was useful for me very much.Thanks a lot once again
Regards,
Anu