Thread: How can i give formula to count the only numbers except zero in a
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mark.dubbelboer@gmail.com is offline
external usenet poster
  
Posts: 1
Default How can i give formula to count the only numbers except zero i
Try a sumproduct:
=SUMPRODUCT(--ISNUMBER(A1:A3),--(A1:A3<0))
Anuja wrote:
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




Reply With QuoteReply With Quote