Countif function for instances of text string contained
 

....that formula you have at the bottom of your post should work fine. Is it
not?

--
Regards,
Dave


"Garbunkel" wrote:

Hello,

I have a 2 column worksheet, & am attempting to
get a count of how many rows contain certain text
strings. Example:
269A560-01_39
269A560-01_41 5
269A560-01_42
269A560-01_43
269A560-01_45
269A560-01_46
269A560-01_57

The second column has a count of how many times
the fragment "269A560-01_4" occurs & if I hard code
that fragment into the formula, it works fine:

=COUNTIF(A1:A9,"269A560-01_4"&"*")

What I would like to know, is whether there a way
to reference a cell number instead of hard coding the
text fragment into the formula such that I could replace
the above line with:
=COUNTIF(A1:A9,C25 &"*")

With C25 containing the actual text fragment & the
count of cells in column A that contain it are returned.

Thanks!
--

Thanks!

Apparently I had to close & reopen Excel to see the results (??)

--



"David Billigmeier" wrote:

...that formula you have at the bottom of your post should work fine. Is it
not?

--
Regards,
Dave


"Garbunkel" wrote:

Hello,

I have a 2 column worksheet, & am attempting to
get a count of how many rows contain certain text
strings. Example:
269A560-01_39
269A560-01_41 5
269A560-01_42
269A560-01_43
269A560-01_45
269A560-01_46
269A560-01_57

The second column has a count of how many times
the fragment "269A560-01_4" occurs & if I hard code
that fragment into the formula, it works fine:

=COUNTIF(A1:A9,"269A560-01_4"&"*")

What I would like to know, is whether there a way
to reference a cell number instead of hard coding the
text fragment into the formula such that I could replace
the above line with:
=COUNTIF(A1:A9,C25 &"*")

With C25 containing the actual text fragment & the
count of cells in column A that contain it are returned.

Thanks!
--

Hmm, you might have automatic calculation turned off. To change, go
Tools-Options-'Calculation' Tab-Select Automatic


--
Regards,
Dave


"Garbunkel" wrote:

Thanks!

Apparently I had to close & reopen Excel to see the results (??)

--



"David Billigmeier" wrote:

...that formula you have at the bottom of your post should work fine. Is it
not?

--
Regards,
Dave


"Garbunkel" wrote:

Hello,

I have a 2 column worksheet, & am attempting to
get a count of how many rows contain certain text
strings. Example:
269A560-01_39
269A560-01_41 5
269A560-01_42
269A560-01_43
269A560-01_45
269A560-01_46
269A560-01_57

The second column has a count of how many times
the fragment "269A560-01_4" occurs & if I hard code
that fragment into the formula, it works fine:

=COUNTIF(A1:A9,"269A560-01_4"&"*")

What I would like to know, is whether there a way
to reference a cell number instead of hard coding the
text fragment into the formula such that I could replace
the above line with:
=COUNTIF(A1:A9,C25 &"*")

With C25 containing the actual text fragment & the
count of cells in column A that contain it are returned.

Thanks!
--