View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anuja Anuja is offline
external usenet poster
 
Posts: 5
Default How can i give formula to count the only numbers except zero in a

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