counting with a criteria in multiple transactions

[shafali]

I want to count the number of persons who have done transactions in a
particular range where one person has done many transactions

 

[Don]

Try:

=SUM(1/COUNTIF(C2:C13,C2:C13))

Enter as an array formula (Ctrl/Shift/Enter)

Don