Total                              675          6

Hi, I need a formula that will count 1 transaction for each. Sometimes I have more lines. I need a fourmula that will count 1 for each transaction and total numbers of tranaction occured. I had done long time ago, could not figure out.

If a1>.01=1 then a1<.01=0

Thanks

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