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 |