using countif without a range

[hawley]

I am trying to use a countif statement but I want don't want to look at a whole range just certain cells. I have tried different things but I keep getting an error. Here is something like I am trying.

I just want to look at cells T17, T20 and T30 but nothing in between.
=IF(COUNTIF((T17,T20,T30),"X")>0,"X","no")

If you have any suggestions let me know.
Thanks-

 

[Mark W.]

The 1st argument of COUNTIF must be a cell range. A cell range is defined as...

"To refer to a range of cells, enter the reference for the cell in the upper-left corner of the range, a colon ), and then the reference to the cell in the lower-right corner of the range."

 

[Al Chara]

Try the following:

=IF(SUMPRODUCT((T17>0)*(T20>0)*(T30>0))=1,"X","no")

 

[Aladin Akyurek]

On 2002-04-08 09:15, hawley wrote:
I am trying to use a countif statement but I want don't want to look at a whole range just certain cells. I have tried different things but I keep getting an error. Here is something like I am trying.

I just want to look at cells T17, T20 and T30 but nothing in between.
=IF(COUNTIF((T17,T20,T30),"X")>0,"X","no")

If you have any suggestions let me know.
Thanks-

It seems just an "X" in one the target cells is sufficient, to return as result an "X", otherwise a "no".

=IF(SUMPRODUCT((T17="X")+(T20="X")+(T30="X"))>0,"X","no")

would do that job.

 

[Mark W.]

On 2002-04-08 09:36, Aladin Akyurek wrote:

On 2002-04-08 09:15, hawley wrote:
I am trying to use a countif statement but I want don't want to look at a whole range just certain cells. I have tried different things but I keep getting an error. Here is something like I am trying.

I just want to look at cells T17, T20 and T30 but nothing in between.
=IF(COUNTIF((T17,T20,T30),"X")>0,"X","no")

If you have any suggestions let me know.
Thanks-

It seems just an "X" in one the target cells is sufficient, to return as result an "X", otherwise a "no".

=IF(SUMPRODUCT((T17="X")+(T20="X")+(T30="X"))>0,"X","no")

would do that job.

To me it looks like hawley wants to evalute a 4 element set consisting of {T17,T20,T30,"X"}.

 

[Al Chara]

Oops, I missed the bit about X being in there.

=IF(SUMPRODUCT((T17="X")*(T20="X")*(T30="X"))=1,"X","no")
This message was edited by Al Chara on 2002-04-08 09:54

 

[Aladin Akyurek]

On 2002-04-08 09:38, Mark W. wrote:

On 2002-04-08 09:36, Aladin Akyurek wrote:

On 2002-04-08 09:15, hawley wrote:
I am trying to use a countif statement but I want don't want to look at a whole range just certain cells. I have tried different things but I keep getting an error. Here is something like I am trying.

I just want to look at cells T17, T20 and T30 but nothing in between.
=IF(COUNTIF((T17,T20,T30),"X")>0,"X","no")

If you have any suggestions let me know.
Thanks-

It seems just an "X" in one the target cells is sufficient, to return as result an "X", otherwise a "no".

=IF(SUMPRODUCT((T17="X")+(T20="X")+(T30="X"))>0,"X","no")

would do that job.

To me it looks like hawley wants to evalute a 4 element set consisting of {T17,T20,T30,"X"}.

If so, I'll try to cope.

 

[hawley]

Thanks for the help everyone. What I ended up using was this
IF(SUMPRODUCT((T10="X")+(T20="X")+(T30="X"))>0,"X","no")

I also found this will work but the above is less typing.
IF((COUNTIF(T10,"X")+COUNTIF(T20,"X")+COUNTIF(T30,"X"))>0,"X","no")