| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wildcard in countif formula that uses cell references
Hi
I have a spreadsheet that contains a column which has several items in each cell. I have created a column (A) on another sheet (in the same workbook) that lists those items separately. Is there any way to have a formula like this, that actually works?: =COUNTIF('sheet2'!I:I,sheet1!A10) At the moment, it only returns a non-zero value for those cells which ONLY contain the item listed in A10. I have tried inserting a wildcard (*) but it just returns an error. Thanks! Terry |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
wildcard in countif formula that uses cell references
Try it like this:
=COUNTIF('sheet2'!I:I,"*"&sheet1!A10&"*") HTH, Elkar "Terry Freedman" wrote: Hi I have a spreadsheet that contains a column which has several items in each cell. I have created a column (A) on another sheet (in the same workbook) that lists those items separately. Is there any way to have a formula like this, that actually works?: =COUNTIF('sheet2'!I:I,sheet1!A10) At the moment, it only returns a non-zero value for those cells which ONLY contain the item listed in A10. I have tried inserting a wildcard (*) but it just returns an error. Thanks! Terry |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
wildcard in countif formula that uses cell references
On Nov 2, 5:15 pm, Elkar wrote:
Try it like this: =COUNTIF('sheet2'!I:I,"*"&sheet1!A10&"*") HTH, Elkar "Terry Freedman" wrote: Hi I have a spreadsheet that contains a column which has several items in each cell. I have created a column (A) on another sheet (in the same workbook) that lists those items separately. Is there any way to have a formula like this, that actually works?: =COUNTIF('sheet2'!I:I,sheet1!A10) At the moment, it only returns a non-zero value for those cells which ONLY contain the item listed in A10. I have tried inserting a wildcard (*) but it just returns an error. Thanks! Terry WOW! That is fantastic!!! Thank u so much. I spent an hour trying to figure that out! Terry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell references in a countif function? | Excel Discussion (Misc queries) | |||
| COUNT or COUNTIF using wildcard text? | Excel Worksheet Functions | |||
| SUMPRODUCT, COUNTIF and wildcard | Excel Worksheet Functions | |||
| How do I use a wildcard or multiple of a cell value in a formula? | Excel Worksheet Functions | |||
| Countif using Wildcard * and number 1 | Excel Worksheet Functions | |||
Linear Mode
