counting with a criteria in multiple transactions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

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

Don
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum, Average, and Count from imported .txt file 2
Access Updating inventory levels 0
Count my Customers 4
Weighted Average 4
SUMIFS with Trim 2
Lookup info in one Column and then returning info in other columns 1
Counting/Matching 2
Need to fix macro to list data underneath each other 17

Back
Top