Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif function question
I have a basic knowledge of countif but I am trying to use it to count if a
value is contained in the cell instead of equals the cell value. Example I would like to count the number of occurences of the phrase " blue book" in the range below blue book blue book, red shoe, yellow car blue book, brown box |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif function question
Will the phrase 'blue book' always be on the left of the cell?
Mike "dveenhuis" wrote: I have a basic knowledge of countif but I am trying to use it to count if a value is contained in the cell instead of equals the cell value. Example I would like to count the number of occurences of the phrase " blue book" in the range below blue book blue book, red shoe, yellow car blue book, brown box |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif function question
=COUNTIF(A:A,"*blue book*")
"dveenhuis" wrote: I have a basic knowledge of countif but I am trying to use it to count if a value is contained in the cell instead of equals the cell value. Example I would like to count the number of occurences of the phrase " blue book" in the range below blue book blue book, red shoe, yellow car blue book, brown box |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif function question
I love you Teethless mama, and your formula. You are a life saver!
-- Please post all your inquiries on this community so we can all benefit - Thank you! "Teethless mama" wrote: =COUNTIF(A:A,"*blue book*") "dveenhuis" wrote: I have a basic knowledge of countif but I am trying to use it to count if a value is contained in the cell instead of equals the cell value. Example I would like to count the number of occurences of the phrase " blue book" in the range below blue book blue book, red shoe, yellow car blue book, brown box |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question re COUNTIF function - reading data from a differnet sheet | Excel Discussion (Misc queries) | |||
A question about the Count/CountIf function | Excel Worksheet Functions | |||
CountIf Function Question | Excel Discussion (Misc queries) | |||
countif question | Excel Worksheet Functions | |||
Countif/Sumif function question | Excel Worksheet Functions |