COUNTIF with multiple conditions
 

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.

COUNTIF with multiple conditions
 

Try: =IF(COUNTIF(C2:C100,"X")=1,"pure play","not pure play")

Dave
--
Brevity is the soul of wit.


"Eric" wrote:

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.

COUNTIF with multiple conditions
 

Thanks, but that doesn't do what I need to do. A pure play is defined as a
row (not a column) in which there's an X in only one column of the row. What
I'm trying to do is for each column, to count those pure play rows which are
pure plays by virtue of the fact that they have the X in that particular
column.

Thanks.

"Dave F" wrote:

Try: =IF(COUNTIF(C2:C100,"X")=1,"pure play","not pure play")

Dave
--
Brevity is the soul of wit.


"Eric" wrote:

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.

COUNTIF with multiple conditions
 

see response to your question posted in worksheet.functions

--
Regards

Roger Govier


"Eric" wrote in message
...
Thanks, but that doesn't do what I need to do. A pure play is defined
as a
row (not a column) in which there's an X in only one column of the
row. What
I'm trying to do is for each column, to count those pure play rows
which are
pure plays by virtue of the fact that they have the X in that
particular
column.

Thanks.

"Dave F" wrote:

Try: =IF(COUNTIF(C2:C100,"X")=1,"pure play","not pure play")

Dave
--
Brevity is the soul of wit.


"Eric" wrote:

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.