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!
--
Hi Garbunkel
I'm using excel 2000 and =COUNTIF(A1:A9,C25 &"*") works for me, the
problem may well be with the format of the data
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread:
http://www.excelforum.com/showthread...hreadid=474967