yes, thanks


"Domenic" wrote:

Try replacing...

D1

with

D1+0

Does this help?

In article ,
j2thea wrote:

the formula works, its the fact that I'm using a concatenated string as my
key value. It passes in the CountIF portion, but it fails in the SMALL(IF
formula. I'm using the formula you provided with the sheet reference in a
previous reply. My key value is D1.

How do I get the String to be a number reference I can use?