Countif based of partial cell contents

[Tony S.]

II need help modifying a formula.
=COUNTIF($D$6:$D$1006,H1)
This returns the count for the value in H1 fine, but I need to modify it so
it will still return the correct number if there are spaces or characters
before or after the value in H1.

Example:
If H1 contains "BBDC3245---" or a space exists before or after " BBDC3245 "
,I want to still count all the occurrences of that base number in col D6to
D1006. I guess I need kind of a wild card search?

 

[T. Valko]

Try this:

H1 = BBDC3245 (no spaces)

=COUNTIF(D61006,"*"&H1&"*")

 

[Tony S.]

That works great for no spaces. Thanks for the help.
--
Tony S.

Try this:

H1 = BBDC3245 (no spaces)

=COUNTIF(D61006,"*"&H1&"*")

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

That works great for no spaces. Thanks for the help.