Countif based of partial cell contents

T

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif Conditions - Use of conditions that vary by cell value 1
How to store the calculated value into the original cell? 1
Return value using partial value of a cell. 2
With F1 value, look at A, if match or partial match return B 5
Counting the number of unique values within a range 5
Selectively replace cells based on two ranges of criteria - nestedIF() statements? 1
How to count with values from multiple columns? 5
Format sheet based on column contents 1

Top