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