Remember Me?

#1
January 22nd 06, 09:43 AM posted to microsoft.public.excel.worksheet.functions
 Sharon Mann Posts: n/a
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 ("").

Sharon

#2
January 22nd 06, 09:49 AM posted to microsoft.public.excel.worksheet.functions
 Roger Govier Posts: n/a
How to check multiple cells

Hi Sharon

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

--
Regards

Roger Govier

"Sharon Mann" wrote in message
news
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 ("").

Sharon

#3
January 22nd 06, 10:12 AM posted to microsoft.public.excel.worksheet.functions
 Sharon Mann Posts: n/a
How to check multiple cells

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

"Roger Govier" wrote in message
...
Hi Sharon

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

--
Regards

Roger Govier

"Sharon Mann" wrote in message
news
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 ("").

Sharon

#4
January 22nd 06, 03:35 PM posted to microsoft.public.excel.worksheet.functions
 Dave Peterson Posts: n/a
How to check multiple cells

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" wrote in message
...
Hi Sharon

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

--
Regards

Roger Govier

"Sharon Mann" wrote in message
news
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 ("").

Sharon

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post telewats Excel Worksheet Functions 2 January 20th 06 11:30 PM riley454 Excel Worksheet Functions 1 January 19th 06 04:00 PM jrambo63 New Users to Excel 1 May 26th 05 06:56 PM jrambo63 Excel Worksheet Functions 3 May 26th 05 05:50 PM gkline Excel Worksheet Functions 2 November 19th 04 08:30 AM

All times are GMT +1. The time now is 08:53 AM.