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

G

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
 
G

Guest

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

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
 
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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top