COUNTIF
 

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!

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!

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!


.

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!


.