Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've got a table A2:Z100, with X's in some of the cells. A row may have one
or multiple Xs. I'm trying to find the number of rows which are "pureplays", which is defined as a row with only one X. For each column, I'd like to count the number of pureplays for that column only, and put that value in the top row. So, for example, C1 would count the number rows that have contain one X only and that X is in column C. (I can't figure out how to do it with COUNTIF. A formula COUNTIF(C2:C100,"X") will count the number of Xs in column C, but it's not limited to the rows containing only one X.) Any ideas?? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif & Sumif with Multiple criteria | Excel Worksheet Functions | |||
CountIf with multiple conditions | Excel Worksheet Functions | |||
COUNTIF and multiple conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
COUNTIF using multiple conditions? | New Users to Excel |