1. Column A, rows 1-10 contain text. Column B, rows 1-10 contain data (numbers). What I would like to do is enter a formula in each of the cells in column C, rows 1-10, that would insert the data that is in the respective cell in Column B in the respective cell in Column C, but only if in the same row in Column A the word "Red" is in the text. Any ideas?

2. Why would you use SUMIF for that?
Enter this formula in C1:

=IF(A1="Red",B1,"")

and fill down to C10.

3. Originally Posted by HansV
Why would you use SUMIF for that?
Enter this formula in C1:

=IF(A1="Red",B1,"")

and fill down to C10.
Not quite, for you see the "Text" in the cells in Column A may, and in many instances, does, contain other words as well as "Red". I tried using a wildcard format such as If(A1="*Red*",B1,""), but it didn't work either-it returns a zero for all of the rows despite the fact that several of the cells in Column A contained text that included "Red".

4. Try

=IF(ISERROR(SEARCH("Red",A1)),"",B1)

This is not case-sensitive. If you want it to be case-sensitive, use

=IF(ISERROR(FIND("Red",A1)),"",B1)

5. Thanks Hans, sorry I wasn't more clear in my initial request.

6. No problem!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•