Posted by: Sharp August 18, 2008
Excel formula
Login in to Rate this Post:     0       ?        

Syanjali, huna ta ma Tanahu ko hu, tara just 10 mins from syangja Boarder, use the countif function

=COUNTIF(A1:A7,">.01")

i had my data range in cell A1 thru A7 and >.01 was the minimum criteria to count,

Hope it will be helpful to you. BTW donot forget to use quotation marks

Read Full Discussion Thread for this article