Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 22nd 06, 08:43 AM posted to microsoft.public.excel.worksheet.functions
Sharon Mann
 
Posts: n/a
Default 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



  #2   Report Post  
Old January 22nd 06, 08:49 AM posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default 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 ("").

Any takers? Thanks in advance!

Sharon



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

Any takers? Thanks in advance!

Sharon





  #4   Report Post  
Old January 22nd 06, 02:35 PM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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 ("").

Any takers? Thanks in advance!

Sharon




--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count if cells have multiple data telewats Excel Worksheet Functions 2 January 20th 06 10:30 PM
make multiple cells in 1 worksheet equal multiple cells in another riley454 Excel Worksheet Functions 1 January 19th 06 03:00 PM
Adding separate accumulators for multiple cells jrambo63 New Users to Excel 1 May 26th 05 06:56 PM
Adding an accumulator for multiple cells jrambo63 Excel Worksheet Functions 3 May 26th 05 05:50 PM
Counting "rows", i.e. simultaneous criteria for multiple cells gkline Excel Worksheet Functions 2 November 19th 04 07:30 AM


All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017