I think you want the formula distinguish between true 1 and 1 that
occurs in such items like 11...

=SUMPRODUCT(ISNUMBER(SEARCH(CHAR(10)&B1&CHAR(10),C HAR(10)&$A$1:$A$7&CHAR(10)))+0)0

would be more compact.

peacelittleone wrote:
This is what ended up working:

=COUNTIF($A$1:$A$7,B1)+COUNTIF($A$1:$A$7,B1&CHAR(1 0)&"*")+COUNTIF($A$1:$A$7,"*"&CHAR(10)&B1)+COUNTIF ($A$1:$A$7,"*"&CHAR(10)&B1&CHAR(10)&"*")

Where I had to conver the values in column B to text:
=text(B1,"0")


Thanks for getting me started!

Heather.