Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count of records with 2 or more "options" selected
Hi
I want to count the number of records where any 2 of 9 options are selected (with an "x' in the cell). Again, they can be any 2 of the 9 options. Likewise, I then need to know how many have any 3, 4, and 5+ of 9 options selected... I hope someone can let me know an easy way to do this. Thanks, Monish |
#2
|
|||
|
|||
count of records with 2 or more "options" selected
Hi!
Use a helper column at the end of your data range that counts the number of X's per row: =COUNITF(B2:J2,"X") Copy down as needed. Then use that helper column as the range to count for the specific number criteria: =COUNTIF(K2:K10,2) =COUNTIF(K2:K10,"5") Biff "Monish" wrote in message ... Hi I want to count the number of records where any 2 of 9 options are selected (with an "x' in the cell). Again, they can be any 2 of the 9 options. Likewise, I then need to know how many have any 3, 4, and 5+ of 9 options selected... I hope someone can let me know an easy way to do this. Thanks, Monish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selected cells: item count versus summation | Excel Discussion (Misc queries) | |||
Count age and gender records from two different columns | Excel Worksheet Functions | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Filter Count of Records Retrieved. | Excel Discussion (Misc queries) | |||
count the no.of records between two dates | Excel Worksheet Functions |