Thread: using Exact with isnumber

I want to use "exact" insted of "search" in column G because of cell b4.

exact and search retun true but when i put into isnumber i dont get the result i am expecting see I2

does not work {
=IF(OR(D3=0,D3=""),"",SUMPRODUCT(--ISNUMBER(EXACT("Yes",Con)),--ISNUMBER(EXACT(D3,List))))
/} (Ctrl+Shift+Enter)

I'm afraid it is impossible to tell what you are trying to do from your description, and it is just as impossible to tell from your sample file which does not have explanations or data that is meaningful.

It is even more impossible to tell why the result you are getting is not what you want.

I suggest you describe what you are trying to do and what are the relationships among all the data.

I want a formula that will tell me the number of times "aa" ONLY is entered in List (B2:B17) with Yes next to it in Con (A2:A17) not to include aag (B4).

i wanted to change search with exact thinking the result would be 2 in cell G2.

Does this work and if not why? What should be returned?

In J2 returns 2

=SUMPRODUCT(--(Con="Yes"),--(List=$J$1))

No problem, we all have moments of over complicting things.

Glad it is all sorted for you.