| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
counting with a criteria in multiple transactions
I want to count the number of persons who have done transactions in a
particular range where one person has done many transactions |
|
#2
|
|||
|
|||
|
Try:
=SUM(1/COUNTIF(C2:C13,C2:C13)) Enter as an array formula (Ctrl/Shift/Enter) Don "shafali" wrote in message ... I want to count the number of persons who have done transactions in a particular range where one person has done many transactions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
| calculate percent from multiple criteria | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Hybrid Mode
