How to check multiple cells

First, thanks to pdberger and Ron Rosenfeld for my earlier question. This is
sort of the opposite problem:

On Sheet1, starting with A1 is a 2 column table:

Standby -
Minimum -
Moderate X
Full -

On Sheet2 I want to enter a string of text in a cell if ANY of the cells in
Sheet1!B1 to B4 contain an "X". If none of the cells contain the "X", then I
want to enter nothing ("").

Any takers? Thanks in advance!

Sharon

Hi Sharon

One way
=IF(COUNTIF(Sheet1!B1:B4,"X")>0,"yourtext","")

--
Regards

Roger Govier


"Sharon Mann" <[email protected]> wrote in message
news:[email protected]...
> First, thanks to pdberger and Ron Rosenfeld for my earlier question.
> This is sort of the opposite problem:
>
> On Sheet1, starting with A1 is a 2 column table:
>
> Standby -
> Minimum -
> Moderate X
> Full -
>
> On Sheet2 I want to enter a string of text in a cell if ANY of the
> cells in Sheet1!B1 to B4 contain an "X". If none of the cells contain
> the "X", then I want to enter nothing ("").
>
> Any takers? Thanks in advance!
>
> Sharon
>

Thanks, Roger! I've never used COUNTIF. Cool!


"Roger Govier" <[email protected]> wrote in message
news:%[email protected]...
> Hi Sharon
>
> One way
> =IF(COUNTIF(Sheet1!B1:B4,"X")>0,"yourtext","")
>
> --
> Regards
>
> Roger Govier
>
>
> "Sharon Mann" <[email protected]> wrote in message
> news:[email protected]...
>> First, thanks to pdberger and Ron Rosenfeld for my earlier question. This
>> is sort of the opposite problem:
>>
>> On Sheet1, starting with A1 is a 2 column table:
>>
>> Standby -
>> Minimum -
>> Moderate X
>> Full -
>>
>> On Sheet2 I want to enter a string of text in a cell if ANY of the cells
>> in Sheet1!B1 to B4 contain an "X". If none of the cells contain the "X",
>> then I want to enter nothing ("").
>>
>> Any takers? Thanks in advance!
>>
>> Sharon
>>
>
>

Debra Dalgleish has a bunch of notes about counting cells at:
http://contextures.com/xlFunctions04.html



Sharon Mann wrote:
>
> Thanks, Roger! I've never used COUNTIF. Cool!
>
> "Roger Govier" <[email protected]> wrote in message
> news:%[email protected]...
> > Hi Sharon
> >
> > One way
> > =IF(COUNTIF(Sheet1!B1:B4,"X")>0,"yourtext","")
> >
> > --
> > Regards
> >
> > Roger Govier
> >
> >
> > "Sharon Mann" <[email protected]> wrote in message
> > news:[email protected]...
> >> First, thanks to pdberger and Ron Rosenfeld for my earlier question. This
> >> is sort of the opposite problem:
> >>
> >> On Sheet1, starting with A1 is a 2 column table:
> >>
> >> Standby -
> >> Minimum -
> >> Moderate X
> >> Full -
> >>
> >> On Sheet2 I want to enter a string of text in a cell if ANY of the cells
> >> in Sheet1!B1 to B4 contain an "X". If none of the cells contain the "X",
> >> then I want to enter nothing ("").
> >>
> >> Any takers? Thanks in advance!
> >>
> >> Sharon
> >>
> >
> >

--

Dave Peterson