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

A

Anuja

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
[email protected]
Thanks,
Anu
 
A

Anuja

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

Anuja

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
 
T

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
 
A

Anuja

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