Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi everyone,
I have a question regarding the COUNTIF function. How do I use this function to count the number of times a record appears when I only enter a portion of the search data. eg. I have a column of data that, among other things, contains text as "anautoalert". How do I write the COUNTIF to simply count the number of times that "auto" appears? Thanks! |
#2
![]() |
|||
|
|||
![]()
Hi James
=COUNTIF(A1:A100,"*auto*") Cheers JulieD "James" wrote in message ... Hi everyone, I have a question regarding the COUNTIF function. How do I use this function to count the number of times a record appears when I only enter a portion of the search data. eg. I have a column of data that, among other things, contains text as "anautoalert". How do I write the COUNTIF to simply count the number of times that "auto" appears? Thanks! |
#3
![]() |
|||
|
|||
![]()
Many thanks JulieD
James -----Original Message----- Hi James =COUNTIF(A1:A100,"*auto*") Cheers JulieD "James" wrote in message ... Hi everyone, I have a question regarding the COUNTIF function. How do I use this function to count the number of times a record appears when I only enter a portion of the search data. eg. I have a column of data that, among other things, contains text as "anautoalert". How do I write the COUNTIF to simply count the number of times that "auto" appears? Thanks! . |
#4
![]() |
|||
|
|||
![]()
you're welcome
"James" wrote in message ... Many thanks JulieD James -----Original Message----- Hi James =COUNTIF(A1:A100,"*auto*") Cheers JulieD "James" wrote in message ... Hi everyone, I have a question regarding the COUNTIF function. How do I use this function to count the number of times a record appears when I only enter a portion of the search data. eg. I have a column of data that, among other things, contains text as "anautoalert". How do I write the COUNTIF to simply count the number of times that "auto" appears? Thanks! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |