Posted by: Sharp August 18, 2008
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